CFMail does this already. Here's an example from the manual:
<CFMAIL QUERY="GetCustomers"
FROM="[EMAIL PROTECTED]"
TO="#EMail#"
SUBJECT="Contact Info
Verification">
Dear #FirstName# -
We'd like to verify that our
customer
database has the most
up-to-date contact
information for your firm. Our
current
information is as follows:
Company Name: #Company#
Contact: #FirstName# #LastName#
Address:
#Address1#
#Address2#
#City#, #State# #Zip#
Phone: #Phone#
Fax: #Fax#
Home Page: #HomePageURL#
Please let us know if any of
the above
information has changed, or if
we need to
get in touch with someone else
in your
organization regarding this
request.
Thanks,
Allaire Customer Service
[EMAIL PROTECTED]
</CFMAIL>
Regards,
Howie
----- Original Message -----
From: George Loch <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, April 26, 2000 11:25 AM
Subject: Custom tag for generating email
> Does anyone know of a tag that would allow for the creation of an email
> message that is automatically generated and sent to a DB of email
addresses.
> It is like a weekly newsletter that let's people know what's new for the
> week.
>
> Thanks
>
> George Loch
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.