I would just do something like this then.
<CFQUERY NAME="GetRecipients" DATASOURCE="#DataSource#">
SELECT * FROM Recipients
</CFQUERY>
<cfloop query="GetRecipients">
<cfmail to="#GetRecipients.Email#" from="#sender_email#"
subject="My Message To You 2009" >
#sender_date#
Dear #GetRecipients.Name#
This is my message to the recipient. This is my message to the
recipient. This is my message to the recipient. This is my message to
the recipient. This is my message to the recipient. This is my message
to the recipient. This is my message to the recipient. This is my
message to the recipient.
Yours truly,
#sender_firstname# #sender_lastname#
#sender_address#
#sender_city#, #sender_state# #sender_zip#
#sender_email#
</cfmail>
</cfloop>
-----Original Message-----
From: cfcom [mailto:cf...@aceligent.com]
Sent: Monday, January 05, 2009 2:21 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop
Yes, it is stored. I can store form_sender and recipients if necessary
-----Original Message-----
From: webmas...@pegweb.com [mailto:webmas...@pegweb.com]
Sent: 2009-01-05 2:13 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop
Is the recipient data stored in a table by chance?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317416
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
