RE: Personalizing a CFLoop - validation error- fixed
I separated the Recipients and Senders into two different tables and the validation error resolved. Thanks so much! -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 4:28 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error The only reason it should give you that error is if there is an empty email for one of the records. Try dumping out the same query to a cfoutput to verify. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop - validation error
It's more like a newsletter, except it's not sent out by site owner to all
the members - but from individual that is filling out the form. So have to
personalize apx. one hundred different members on list of 'TO' and end it
personalized in the 'FROM'.
-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com]
Sent: 2009-01-05 4:38 PM
To: cf-talk
Subject: RE: Personalizing a CFLoop - validation error
Agreed. If you are having problems finding the offending record, just
wrap a try around the cfmail and output that record in the catch.
I am slightly confused as to exactly what you are building. At first I
assumed it was something like an "E-mail this page to a friend" feature
on your site, but now it sounds more like a newsletter feature.
If you know your E-mails are all valid, the cfmail tag actually has a
query attribute for the purpose of sending out an E-mail to everyone in
a resultset.
~Brad
Original Message ----
Subject: RE: Personalizing a CFLoop - validation error
From:
Date: Mon, January 05, 2009 3:27 pm
To: cf-talk
The only reason it should give you that error is if there is an empty
email for one of the records. Try dumping out the same query to a
cfoutput to verify.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
Agreed. If you are having problems finding the offending record, just
wrap a try around the cfmail and output that record in the catch.
I am slightly confused as to exactly what you are building. At first I
assumed it was something like an "E-mail this page to a friend" feature
on your site, but now it sounds more like a newsletter feature.
If you know your E-mails are all valid, the cfmail tag actually has a
query attribute for the purpose of sending out an E-mail to everyone in
a resultset.
~Brad
Original Message
Subject: RE: Personalizing a CFLoop - validation error
From:
Date: Mon, January 05, 2009 3:27 pm
To: cf-talk
The only reason it should give you that error is if there is an empty
email for one of the records. Try dumping out the same query to a
cfoutput to verify.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317425
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop - cfmail validation error
No still throwing validation error. For the most part the application is now working - if I can only eliminate the error. -Original Message- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: 2009-01-05 4:20 PM To: cf-talk Subject: Re: Personalizing a CFLoop - validation error I know this will sound odd, but put them on separate lines... so this: becomes this: I have always found that with CFMAIL, it likes it better when the arguments are on different lines. HTH Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop - validation error
The only reason it should give you that error is if there is an empty email for one of the records. Try dumping out the same query to a cfoutput to verify. -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 4:14 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error They all have email addresses, I just don't know why it's throwing the validation error on the CFMail 'TO'. I want to send out to about 100 different addresses, is there any issues with that? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop - validation error
Ok, I'll try. -Original Message- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: 2009-01-05 4:20 PM To: cf-talk Subject: Re: Personalizing a CFLoop - validation error I know this will sound odd, but put them on separate lines... so this: becomes this: I have always found that with CFMAIL, it likes it better when the arguments are on different lines. HTH Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Personalizing a CFLoop - validation error
I know this will sound odd, but put them on separate lines... so this: becomes this: I have always found that with CFMAIL, it likes it better when the arguments are on different lines. HTH Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
They all have email addresses, I just don't know why it's throwing the validation error on the CFMail 'TO'. I want to send out to about 100 different addresses, is there any issues with that? -Original Message- From: Billy Cox [mailto:bi...@oldworldspices.com] Sent: 2009-01-05 4:07 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error How about amending your query to only return results that have an email address? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 3:01 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error I added four columns to database; 'recip_firstname, recip_lastname, recip_title, recip_email'. Now all the 'sender and recipient' data in the same table of db, but I keep getting an error: //Attribute validation error for tag CFMAIL. //The value of the attribute TO is invalid. The length of the string, 0 //character(s), must be greater than or equal to 1 character(s). SELECT * FROM mytablename #sender_date# Dear #GetRecipients.recip_title# #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #form.sender_firstname# #form.sender_lastname# #form.sender_address# #form.sender_city#, #form.sender_state# #form.sender_zip# #form.sender_email# -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 3:17 PM To: cf-talk Subject: RE: Personalizing a CFLoop I would just do something like this then. SELECT * FROM Recipients #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
How about amending your query to only return results that have an email address? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 3:01 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error I added four columns to database; 'recip_firstname, recip_lastname, recip_title, recip_email'. Now all the 'sender and recipient' data in the same table of db, but I keep getting an error: //Attribute validation error for tag CFMAIL. //The value of the attribute TO is invalid. The length of the string, 0 //character(s), must be greater than or equal to 1 character(s). SELECT * FROM mytablename #sender_date# Dear #GetRecipients.recip_title# #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #form.sender_firstname# #form.sender_lastname# #form.sender_address# #form.sender_city#, #form.sender_state# #form.sender_zip# #form.sender_email# -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 3:17 PM To: cf-talk Subject: RE: Personalizing a CFLoop I would just do something like this then. SELECT * FROM Recipients #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop - validation error
I added four columns to database; 'recip_firstname, recip_lastname, recip_title, recip_email'. Now all the 'sender and recipient' data in the same table of db, but I keep getting an error: //Attribute validation error for tag CFMAIL. //The value of the attribute TO is invalid. The length of the string, 0 //character(s), must be greater than or equal to 1 character(s). SELECT * FROM mytablename #sender_date# Dear #GetRecipients.recip_title# #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #form.sender_firstname# #form.sender_lastname# #form.sender_address# #form.sender_city#, #form.sender_state# #form.sender_zip# #form.sender_email# -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 3:17 PM To: cf-talk Subject: RE: Personalizing a CFLoop I would just do something like this then. SELECT * FROM Recipients #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop
I would just do something like this then. SELECT * FROM Recipients #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop
I would just do something like this then. SELECT * FROM Recipients #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:01 PM To: cf-talk Subject: Personalizing a CFLoop CFLoop Problem: I need to take the contents a visitor enters into our form and use it to send out personalized emails to several recipients. How do I set up the cfloop so that it sends a unique email to each recipient, personalizes the opening sentence and ends it signed by the visitor using the form. So far I can loop to each different address but I am having trouble doing the 'name/email' pair of variables. #sender_date# Dear #_#,(needs to be name as designated by recipient email: 'Bob' for 'b...@domain.com') This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Personalizing a CFLoop
well in your original post, your list contained only email addresses.
If you are going to do a list with a pairing of information (ie Name, email,
name, email, name, email) I would think that going with a 2d array as brad
suggested would make your life easier. Of course if it is stored in the DB
somehow, you can always just query out what you want as well, and loop the
query.
HTH
Rob
On Mon, Jan 5, 2009 at 2:48 PM, cfcom wrote:
> Not sure if I have this right. Some of the recipients Names are not used in
> their email, such as ('Mark Jones', 'mana...@zzz.com') How would that
> structure work?
>
>
>
>
>
>
>
>
>
>
>
>
>
> Dear #left#,
>
> This is my message to the recipient. This is my message to the
> recipient.
>
> Yours truly,
>
> #sender_firstname# #sender_lastname#
>
>
>
> -Original Message-
> From: Rob Parkhill [mailto:robert.parkh...@gmail.com]
> Sent: 2009-01-05 2:08 PM
> To: cf-talk
> Subject: Re: Personalizing a CFLoop
>
> Well I am sure that there is a more elegant REGEX solution, but you can
> always do a FIND and then a LEFT
> so:
>
>
>
>
>
> I am sure someone will post something more elegant, but that will work.
>
> Rob
>
>
>
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317414
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop
Not sure if I have this right. Some of the recipients Names are not used in
their email, such as ('Mark Jones', 'mana...@zzz.com') How would that
structure work?
Dear #left#,
This is my message to the recipient. This is my message to the
recipient.
Yours truly,
#sender_firstname# #sender_lastname#
-Original Message-
From: Rob Parkhill [mailto:robert.parkh...@gmail.com]
Sent: 2009-01-05 2:08 PM
To: cf-talk
Subject: Re: Personalizing a CFLoop
Well I am sure that there is a more elegant REGEX solution, but you can
always do a FIND and then a LEFT
so:
I am sure someone will post something more elegant, but that will work.
Rob
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317413
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop
Lists are pretty one-dimensional. They basically just store a single
string at each index (and I don't really like lists in lists). What you
have is groupings of related data. (name, e-mail)
I would graduate up to a two-dimensional array or a struct.
Or you could get all kinds of fancy an create an array of structs.
E-mail to #recipient.name# (#recipient.email#)
Questions to ask yourself: How many names/emails does your interface
allow a person add? What are the form fields named? Are names in a
repeatable sequence that will allow me to dynamically loop over them?
~Brad
Original Message
Subject: Personalizing a CFLoop
From: "cfcom"
Date: Mon, January 05, 2009 1:00 pm
To: cf-talk
CFLoop Problem:
I need to take the contents a visitor enters into our form and use
it to send out personalized emails to several recipients. How do I set
up
the cfloop so that it sends a unique email to each recipient,
personalizes
the opening sentence and ends it signed by the visitor using the form.
So
far I can loop to each different address but I am having trouble doing
the
'name/email' pair of variables.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317411
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Personalizing a CFLoop
Yes, it is stored. I can store form_sender and recipients if necessary -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:01 PM To: cf-talk Subject: Personalizing a CFLoop CFLoop Problem: I need to take the contents a visitor enters into our form and use it to send out personalized emails to several recipients. How do I set up the cfloop so that it sends a unique email to each recipient, personalizes the opening sentence and ends it signed by the visitor using the form. So far I can loop to each different address but I am having trouble doing the 'name/email' pair of variables. #sender_date# Dear #_#,(needs to be name as designated by recipient email: 'Bob' for 'b...@domain.com') This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Personalizing a CFLoop
Is the recipient data stored in a table by chance? -Original Message- From: cfcom [mailto:cf...@aceligent.com] Sent: Monday, January 05, 2009 2:01 PM To: cf-talk Subject: Personalizing a CFLoop CFLoop Problem: I need to take the contents a visitor enters into our form and use it to send out personalized emails to several recipients. How do I set up the cfloop so that it sends a unique email to each recipient, personalizes the opening sentence and ends it signed by the visitor using the form. So far I can loop to each different address but I am having trouble doing the 'name/email' pair of variables. #sender_date# Dear #_#,(needs to be name as designated by recipient email: 'Bob' for 'b...@domain.com') This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Personalizing a CFLoop
Well I am sure that there is a more elegant REGEX solution, but you can always do a FIND and then a LEFT so: I am sure someone will post something more elegant, but that will work. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Personalizing a CFLoop
Dear #recipName#, >CFLoop Problem: > I need to take the contents a visitor enters into our form and use >it to send out personalized emails to several recipients. How do I set up >the cfloop so that it sends a unique email to each recipient, personalizes >the opening sentence and ends it signed by the visitor using the form. So >far I can loop to each different address but I am having trouble doing the >'name/email' pair of variables. > > > formfields="sender_firstname, sender_lastname, >sender_email, sender_address, sender_city, sender_state, sender_zip, >sender_time, sender_date, sender_ip, sender_msgType"> > > > > > > > > > > > #sender_date# > > > Dear #_#,(needs to be name as designated by recipient email: >'Bob' for 'b...@domain.com') > > > This is my message to the recipient. This is my message to the >recipient. This is my message to the recipient. This is my message to the >recipient. This is my message to the recipient. This is my message to the >recipient. This is my message to the recipient. This is my message to the >recipient. > > > Yours truly, > > #sender_firstname# #sender_lastname# > #sender_address# > #sender_city#, #sender_state# #sender_zip# > #sender_email# > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Personalizing a CFLoop
CFLoop Problem: I need to take the contents a visitor enters into our form and use it to send out personalized emails to several recipients. How do I set up the cfloop so that it sends a unique email to each recipient, personalizes the opening sentence and ends it signed by the visitor using the form. So far I can loop to each different address but I am having trouble doing the 'name/email' pair of variables. #sender_date# Dear #_#,(needs to be name as designated by recipient email: 'Bob' for 'b...@domain.com') This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
