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.

Reply via email to