[thelist] CFML Broadcast Email

Thu Feb 22 12:59:36 CST 2001

Hey all,
I have written below a broadcast email message in CFML that will query a 
live MS DB called mstcont.mdb in table promo1 (as written in the source 
below). This script has been tested and will send an email to about 3000 
email addresses I have stored in the DB. The question I have is that I need 
a way for CFML to send me back a response or confirmation stating whether 
the emails were sent or returned say in the subsystem. I am not totally sure 
that all the email addresses are current or still correct. Is there a way I 
can do this with CFML? Please write back if I am not being specific or clear 
enough.

Thank You

html
<TITLE>Text E-mail by file entry</TITLE>
</HEAD>
<BODY bgcolor ="#ffffff">
<CFQUERY NAME="RECIPIENTS" DATASOURCE="mstcont">
	SELECT * FROM promo1 ORDER BY EmailAcct</CFQUERY>
<CFMAIL TO="#EmailAcct#"
	FROM="info at ddresorts.com"
	SUBJECT="News from Wherever"
	QUERY="RECIPIENTS">
THIS IS A TEST MESSAGE.
</CFMAIL>
<H1>ALL FINISHED!</H1>
<P>Your messages have all been sent.</P>
/html
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com