The website is in CF, but the newsletter is in HTML and saved
to the
database. I need it to merge, with the coldfusion which is
sending the
emails, to produce the name and the html email that is
inserted.
Here is what I have. The campaign.html is an html email that
I need to merge
with the database to include the name.
Just need to figure how to put the #name# into the HTML so
coldfusion first
evaluates the html and then the name inside of it.
<cfloop query="mailist">
<cfmail from="#campaign.emailfrom#" to="#mailist.email#"
failto="bounce@avemarialaw.edu"
replyto="#campaign.emailreply#"
server="****" subject="#campaign.subject#">
<cfoutput>#campaign.html#<br /><br />
Your name has been provided to Ave Maria School of Law by the
Law School
Admissions Council Candidate Referral Service.<br />If
you wish not to
receive future communications, <a
href="
http://www.avemarialaw.edu/mailings/optout.cfm?email=#mailist.email#&name=#mailist.name#">please
click here.</a></cfoutput>
</cfmail>
</cfloop>