RE: Mass Mailings

John Davies ( (no email) )
Wed, 27 May 1998 22:06:09 -0700

>> 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.

If you are running MailSite (http://www.rockliffe.com/mailsite.htm) you could
enter the query directly into the config of the mail list:

Select
EmailAddress=sa.email,
FullName=''
From
SubAccounts sa, MasterAccounts ma
Where
sa.CustomerID = ma.CustomerID AND
sa.AccountType = 'PPP' AND
ma.PayPeriod = 'Monthly' AND
sa.Netsoftware = 'Windows 95'

Regards, John.