PMFJI, but as noted earlier, the following works with a Query,
no place holder needed:
<CFMAIL QUERY="IPList"
FROM="[EMAIL PROTECTED]"
TO="#email#"
SUBJECT="DAILY BUSINESS TIP #FancyDate#">
D A I L Y B U S I N E S S T I P -- Issue Number #IssueNumber#
++++++++++++++#FancyDate#++++++++++++++++
Dear #email#:
Your subscription expires #DateFormat("#expiredate_tip#", "DDDD, MMMM DD,
YYYY")#
blah, blah, blah
best, paul
PS> With complex message bodies, where different parts of the body come
from a database, for example, you need to create the body of the message as
a single string outside of CFMAIL to get around the lack of formatting
inherent if you use the method of having
#Text1#
<CFIF Option2>#Text2#</CFIF>
#Text3#
in the message body.
At 12:29 PM 7/26/00 -0400, you wrote:
> I've tried this before with no luck. I use place holders and do replaces
>on those values.
>
>
>
>Lon Lentz
>Applications Developer - Alvion Technologies
>DataWarehousing and List Sales - Market Your Lists on the Net!
>[EMAIL PROTECTED]
>941-574-8600 Ext. 210
>
>-----Original Message-----
>From: Neil Peaslee [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, July 26, 2000 10:17 AM
>To: cf-talk
>Subject: substituting variables in a variable
>
>
> I am trying to set up a mail system that can grab text from a
> database and
>insert it into a mail message. I also need to customize the text of the
>message (e.g. Dear #first_name# evaluates to Dear John). The problem arises
>when I insert the mail text variable into the <cfmail> tag. The variables
>that are contained in the text message are not evaluated.
><cfmail ..>
> #mail_message#
></cfmail>
>This will output "Dear #first_name#, ..."
>
>How do I get the sub variable to be evaluated?
>
>Thanks in advance,
>Neil
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.