Thanks Brad, I'll see if I can find an example of what you suggested. Best Steve
-----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:02 PM To: CF-Talk Subject: RE: cfloop question Try creating and looping over a query object instead of a list. Then you can have a column in each record for the first name, last name, e-mail, and whatever else you want. The Cfmail tag actually has a query attribute built in for that purpose. Then you output the variables just like you would if you were looping over your query with a cfoutput. Don't forget, query objects don't have to come from a database. You can build one with querynew() etc if you want to hard-code the addresses like your example shows. ~Brad -----Original Message----- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 6:40 PM To: CF-Talk Subject: cfloop question I need to send a personalized letter to a list of recipients. Is there a way to set it up so it can also insert the corresponding 'first name' variable also? <cfset recipients_email="[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]"> <cfloop list="#recipients_email#" index="recipient"> <cfmail to="#recipient_email#" from="[EMAIL PROTECTED]" subject="Please support the team"> Hello #recipient_firstname#: This is my text for the email letter. This is my text for the email letter. This is my text for the email letter. This is my text for the email letter. This is my text for the email letter. </cfmail> </cfloop> No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.1/1299 - Release Date: 2/26/2008 9:08 AM ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
