Well, the concept is what I described but without seeing your code I don't know what your best approach would be.
-----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: 25 October 2005 16:33 To: CF-Newbie Subject: RE: CFMail Functionality Yeah - I think. So, I place the Message Query, CFMail and the MessageTextAmended in a CFloop - and loop through all the EmailSubscribers.... Right? To make each email "unique" or customized for the receiver... I'll try this out and let you know how it works. Thanks! -Nick -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 9:42 AM To: CF-Newbie Subject: RE: CFMail Functionality OK, imaging you have a column in your DB which contains all of your message content and within that message content you have [firstname] and [lastname] in it; you could do the following...(pseudo code) // This will get the message data <cfquery> Select messagectontent from message Where messageid =1 </cfquery // this does the replacing <cfset MessageTextAmended = ReplaceNoCase(messagectontent, "[firstname]", "John Smith", "All")> The variable MessageTextAmended now should contain John Smith in place of the placeholder [firstname] You could do this an infinite amount of times per placeholder/variable. You could of course replace "John Smith" with a DB variables. Make sense? N ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1483 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
