* This is the vopmailbeta mailing list *
You don't actually need a FullName field. You can cheat the system by
using a script as follows:
---
SELECT email as EmailAddress, email as FullName
FROM listmemebers
---
As you can see I'm just using the email address to populate the Full
Name field. You can also use more complex statements to allow data
separation:
---
SELECT LM.email as EmailAddress,
mT.Title + ' ' + mU.ForeName + ' ' + mU.Surname as FullName
FROM ListMemebers as LM
INNER JOIN mstUsers as MU ON LM.email = mU.email
INNER JOIN mstTitles as mT ON mU.TitleID = mT.TitleID
---
Of course, these require you to be using a Database Mailing list and the
above code is based on using MS SQL (although it should work for MS
Access).
---
A woman is like a teabag - only in hot water do you realise how strong
she
is.
(--------------------------------) {((((((
( Suneel Jhangiani ) /_ _ )
( Technical Director ) ( . . )
( Inter-Computer Technology Ltd. ) ( / )
(----------------------------------oOOo------------oOOo----)
( 40 James Street Tel: +44 (0) 20 7486 9601 )
( London W1U 1EU Fax: +44 (0) 7050 678 978 )
( United Kingdom Email: [EMAIL PROTECTED] )
( Website: http://www.inctech.com )
(----------------------------------------------------------)
-----Original Message-----
From: David Payer [mailto:[EMAIL PROTECTED]
Sent: 18 October 2003 00:19
To: [EMAIL PROTECTED]
* This is the vopmailbeta mailing list *
I have solved it by creating database lists and then using off the shelf
ASP
database management packages that allow people to add/remove records. So
far
it works. I never integrated it fully graphically though. Further, they
can't change moderators, except if they use the Java Applet console.
I used table editor from 2eNetworx http://www.2enetworx.com/dev
but here is a list on ASPIN of similar tools, most of which are free:
http://www.aspin.com/func/search?tree=aspin&qry=table+editor&cat=
Lessons learned, you must have a table with at least two fields and
thost
MUST BE:
EmailAddress
FullName
You can have others but you must have these.
Good luck!
David Payer
----- Original Message -----
From: "Robb Bryn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 2:24 PM
Subject: [VOPmail Beta] Mailing lists and webmail
> * This is the vopmailbeta mailing list *
>
>
> I've run into the same ?/problem with Vopmail.
>
> Maybe Yves or Michael could let us know if there is an updated way to
do
> this and let users manage their own lists easier in Vop 6. or Modus 3?
>
> Thanks
> Robb
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:vopmailbeta-
> > [EMAIL PROTECTED] On Behalf Of Darryl Dunkin
> > Sent: Friday, October 17, 2003 3:01 PM
> > To: [EMAIL PROTECTED]
> > Subject: [VOPmail Beta] Mailing lists and webmail
> >
> > * This is the vopmailbeta mailing list *
> >
> >
> > There is the java admin which I don't believe is being developed
> > anymore, this generally works fine. I've worked my way around it,
> > everything from ASP/e-mail subscribing, to FTP/text files and
databases.
> >
> > -----Original Message-----
> > From: Michael Pearl [mailto:[EMAIL PROTECTED]
> > Sent: Friday, October 17, 2003 07:27
> > To: [EMAIL PROTECTED]
> > Subject: [VOPmail Beta] Mailing lists and webmail
> >
> >
> > * This is the vopmailbeta mailing list *
> >
> >
> > Is there a way for the user to admin their mailing list via webmail
> > manager? Should I RTFM or is this not possible? ;)
> >
> > Michael Pearl
> > Aretech Information Services
> > Marysville, MI [EST]
> > http://www.aretech.com
> >
> > **
> > To leave this list, send an email to [EMAIL PROTECTED]
and
> > put the word "LEAVE" in the BODY of the email.
> >
> > **
> > To leave this list, send an email to [EMAIL PROTECTED]
> > and put the word "LEAVE" in the BODY of the email.
>
>
> **
> To leave this list, send an email to [EMAIL PROTECTED]
> and put the word "LEAVE" in the BODY of the email.
>
**
To leave this list, send an email to [EMAIL PROTECTED]
and put the word "LEAVE" in the BODY of the email.
**
To leave this list, send an email to [EMAIL PROTECTED]
and put the word "LEAVE" in the BODY of the email.
