Re: [Emerald] Script Help

PowerNet ( (no email) )
Mon, 31 Jul 2000 13:11:19 -0400


When I try that script I still get the spaces.
But, instead of being behind the email address, they are on a line by=
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.


*********** 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.
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: