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
>> in their emerald accounts (such as service type, pay periods, net software,
>> 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
>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:
SubAccounts sa, MasterAccounts ma
sa.CustomerID = ma.CustomerID AND
sa.AccountType = 'PPP' AND
ma.PayPeriod = 'Monthly' AND
sa.Netsoftware = 'Windows 95'