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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:1478
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
