Yes it is possible and lots of example out there... A common approach is to have the following kind of thing within your message
[fist name][last name] And then replacing these with real data . We built a mail tool which can do this (around 50 personal fields), it can also track emails etc such as who opened it, what links they clicked on etc -----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: 25 October 2005 15:29 To: CF-Newbie Subject: CFMail Functionality Howdy All! I have written a handy tool to email newsletters to my clients or my client's, clients - whomever I have in my database orgainized by group. (Think SPAM, but with membership) You can save the Email "message" in the database and then choose which group to send the message to. Pretty basic, but the message can be anything... HTML, pictures, text - whatever. I want the "Message" to be customizable - and to be able to personalize the email. "Dear John Smith" (Or customizable with any info I have in the DB) I tried writing CF tags in the Mail message to write our the personalization... but that doesn't work. Could it work?? Is it possible??? Code as follows: Saved Message: "Dear <cfoutput>#qryGetEmail.FirstName# #qryGetEmail.LastName#</cfoutput>, With your support and the support of blah blah... Presumably message is wrapped in HTML and graphics to make it sexy!" Sending Code: <cfif IsDefined("FORM.SendCamp") AND FORM.SendCamp EQ "Sent"> <CFMAIL query="qryGetEmailSubs" type="html" SUBJECT="#qryGetEmailCamps.ECTitle#" FROM="[EMAIL PROTECTED]" TO="#qryGetEmailSubs.Email#"> #qryGetEmail.EMMessage# <!--- The saved Message---> <br> <hr> <br> <font face="Arial, Helvetica, sans-serif" size="-2"> © #year(NOW())# #qryGetClient.Name# - All rights reserved.<br> #qryGetClient.Address1#, #qryGetClient.City#, #qryGetClient.State# #qryGetClient.Zip# <br><br> <a href="#qryGetClient.WebAddress#" class="footer">#qryGetClient.WebAddress#</a><br> <br> This email was sent to #qryGetEmailSubs.Email#.<br> If you feel you have received this email by mistake or would like to be removed from our mailing list, please contact us at <a href="mailto:#qryGetClient.Email#"; class="footer">#qryGetClient.Email#</a>. </font> </CFMAIL> <!--- Now update the sent date ---> <cfset Sent = "#Now()#"> <cfquery datasource="#datasource#" username="#username#" password="#password#"> Update EmailCampaign Set DateSent = #Sent# WHERE ECID = #qryGetEmailCamps.ECID# </cfquery> </cfif> Thanks as always everyvbody! -Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
