Re: [Emerald] Script Help

Dale E. Reed Jr. ( (no email) )
Fri, 28 Jul 2000 09:19:30 -0700

> 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=Login + '@' + d.MailDomain + char(13)
> From MasterAccounts ma, SubAccounts sa, Groups g, Domains d
> Where ma.CustomerID = sa.CustomerID
> AND ma.Active=1 and sa.Active=1
> AND g.DomainID = d.DomainID
> AND ma.GroupID = 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