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
>