[First Name] jumped over....
Then I take the whole textbox (let's say FORM.memMessageBox) and loop over a query that contains recipients to send the personalized messages...
with each pass of the loop you replace the place holder ([First Name]) with the value of the first name from the current record in the loop.
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Ian Skinner
To: CF-Talk
Sent: Thursday, May 27, 2004 1:19 PM
Subject: CF-Mail merge application.
I am hoping I can get some feedback on how difficult the following idea would be to implement and any hints on how to maybe done?
This is for an e-mail distribution tool. We have a database that a user can create a customized list of records filtered by many different criteria of their choosing. The tool would then be used to send an e-mail to all the addresses in this generated list a message created by the user in the tool. Very straight forward to this point.
How difficult would be to create a feature that would allow the user to pick one or more fields from the database related to the selected records and include this data in the message in a mail merge type function?
For example the user could create a message something like this in a text box:
#Fname# jumped over the candlestick.
And the e-mails would be sent out something like this:
email 1: Jack jumped over the candlestick.
email 2: Jill jumped over the candlestick.
email 3: Spot jumped over the candlestick.
ect...
What I can't picture yet is how I would process the input from a text box that contained "#Fname# jumped over the candlestick." and have the variable embedded in the string rendered into a value from the corresponding data. And not just output messages that look like this:
email 1: #Fname# jumped over the candlestick.
email 2: #Fname# jumped over the candlestick.
email 3: #Fname# jumped over the candlestick.
ect...
That is what would happen if I just code the cfmail tag like this:
<cfmail ....>
#Form.MailMessage#
</cfmail>
Isn't it?
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
