When I try that script I still get the spaces.
But, instead of being behind the email address, they are on a line by=
themselves.
Is there a script like this to pull email addresses only from active mbr's=
with a return right behind the address and single spaced.
The query below is double spaced and won't work.
Thanks,
John
*********** REPLY SEPARATOR ***********
On 7/28/2000 at 9:19 AM Dale E. Reed Jr. wrote:
>> I am trying to create a script that will pull only active mailboxes on=
my domain.
>> This one works, but in order to use this as a text list in mailsite I=
need a carriage return after each email address.
>>
>> How do I change this script to do that?
>
>It should be pretty easy. Just add:
>
>> Select EMail=3DLogin + '@' + d.MailDomain + char(13)
>> From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
>> Where ma.CustomerID =3D sa.CustomerID
>> AND ma.Active=3D1 and sa.Active=3D1
>> AND g.DomainID =3D d.DomainID
>> AND ma.GroupID =3D g.GroupID
>
>I really don't know why you need to. If its needed, its a bug in
>Mailsite, IMHO. We run all our lists through a DB and don't have
>this on them and they work fine. :)
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT/X
>____________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart