I need to send out bulk emails up to 10,000 at a time that can communicate with a database to pull merged information. I will be sending out html and text emails. The program needs to be able to query to pull information from various tables to populate the email.
You can either provide a program or provide the code with GOOD COMMENTS so that we can change whatever is needed for each campaign.
Following is an example of the code used for the present program we use in Coldfusion. We need something because the basic CFMAIL function in Coldfusion is very limiting.
select * from contacts
where
exists (select * from Colchester_mailing where [login to view URL] = colchester_mailing.c_company)
and status <> 'Do Not Call'
and (email_General <> '' and email_general IS NOT NULL)
and email_general <> 'form'
and (email = '' or email IS NULL)
and not exists (select * from remove_list where contacts.email_general = remove_list.remove_email)
order by company