<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:1484
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
