Hi Mike, That's workable, but you don;t need the cfoutput or cfloop tags if you use the query= parameter in the cfmail tag.
Jenny ----- Original Message ----- From: "Mike Chytracek" <[EMAIL PROTECTED]> To: "CF-Newbie" <[email protected]> Sent: Tuesday, October 25, 2005 4:49 PM Subject: RE: CFMail Functionality > <cfquery name="subscribers"> read in subscribers </cfquery> > > <cfoutput> > <cfloop query="subscribers"> > <cfmail blah blah blah> > Greetings #salutation# #lastname#, > > I want to wish you a very happy #event#. I am looking forward to > seeing you on #apptdate#. I will call you at #phonenumber# if I will not > be > able to attend. > > Sincererly, > > Mike > > </cfmail> > </cfloop> > </cfoutput> > > > > > > -----Original Message----- > From: Nick Sweeney [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 25, 2005 10:33 AM > 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 > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:1487 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
