Gregory E. Keys
System Administrator
LoclNet (A Division of ESC Inc.)
Electro-data Systems Company Inc.
Voice: (704)861-1251
Fax: (704)861-1870
E-Mail: greg@loclnet.com <mailto:greg@loclnet.com>
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Kelly Wright
> Sent: Wednesday, May 27, 1998 7:23 AM
> To: emerald@emerald.iea.com
> Subject: Re: Mass Mailings
>
>
> Does this script work?
>
> I am needing to email all my accounts to notify them of our new access
> number.
>
> Kelly Wright (kelly@buz.net)
> BuzNet Communications
> http://www.buz.net
> 972-644-0440
>
> -----Original Message-----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@emerald.iea.com <emerald@emerald.iea.com>
> Date: Wednesday, April 22, 1998 4:06 PM
> Subject: Re: Mass Mailings
>
>
> >> Greg Keys wrote:
> >>
> >> I need to be able to send e-mail to groups of people based on various
> criteria
> >> in their emerald accounts (such as service type, pay periods, net
> software,
> >> etc)
> >>
> >> Has anyone out there come up with a way of querying the database and
> >> generating mail to those who meet a given criteria?
> >
> >My generic solution for this is to run a query to create a batch file.
> >Something like this:
> >
> >Select Command='blat newmail.txt -t ' + sa.email + ' -s mailing -f
> admin@my.com"
> >From SubAccounts sa, MasterAccounts ma
> >Where sa.CustomerID = ma.CustomerID
> > AND sa.AccountType = 'PPP'
> > AND ma.PayPeriod = 'Monthly'
> > AND sa.Netsoftware = 'Windows 95'
> >
> >Then just cut/paste the results into a batch file and execute it.
> >
> >--
> >Dale E. Reed Jr. (daler@iea-software.com)
> >_________________________________________________________________
> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> > Internet Solutions for Today | http://www.iea-software.com
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
> >
>