Re: Custom tag for generating email
CFMail does this already. Here's an example from the manual: CFMAIL QUERY="GetCustomers" FROM="[EMAIL PROTECTED]" TO="#EMail#" SUBJECT="Contact Info Verification" Dear #FirstName# - We'd like to verify that our customer database has the most up-to-date contact information for your firm. Our current information is as follows: Company Name: #Company# Contact: #FirstName# #LastName# Address: #Address1# #Address2# #City#, #State# #Zip# Phone: #Phone# Fax: #Fax# Home Page: #HomePageURL# Please let us know if any of the above information has changed, or if we need to get in touch with someone else in your organization regarding this request. Thanks, Allaire Customer Service [EMAIL PROTECTED] /CFMAIL Regards, Howie - Original Message - From: George Loch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 26, 2000 11:25 AM Subject: Custom tag for generating email Does anyone know of a tag that would allow for the creation of an email message that is automatically generated and sent to a DB of email addresses. It is like a weekly newsletter that let's people know what's new for the week. Thanks George Loch -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Custom tag for generating email
I've got one that allows users to add or delete their email from a database, then, gives you the ability to email the list in bulk. It also give the admin the ability to add and delete email addresses. It checks for dupes and sends notices when folks add or delete their address. The newsletter can be typed in from the browser on the admin page. Comes with Access datasource. Allows admin to view addresses. Email me off list. Dave - Original Message - From: George Loch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 26, 2000 10:25 AM Subject: Custom tag for generating email Does anyone know of a tag that would allow for the creation of an email message that is automatically generated and sent to a DB of email addresses. It is like a weekly newsletter that let's people know what's new for the week. Thanks George Loch -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Custom tag for generating email
Why not make a database of the users you want them do a cfmail with the message and make the to address the users in the database. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: George Loch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 26, 2000 11:26 AM To: CF-Talk Subject: Custom tag for generating email Does anyone know of a tag that would allow for the creation of an email message that is automatically generated and sent to a DB of email addresses. It is like a weekly newsletter that let's people know what's new for the week. Thanks George Loch -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Custom tag for generating email
It would be pretty easy for you to set up a form where you could enter the content of the message and send it to a page that sends out the letter. Then the cfmail call would just look like this: cfmail query="CustomerAddresses" FROM="[EMAIL PROTECTED]" TO="#EmailAddress#" Subject="#form.SubjectLine#" #form.MessageBody# /cfmail Of course, you would want to restrict access to those files... At 11:49 AM 4/26/00 -0400, you wrote: CFMail does this already. Here's an example from the manual: CFMAIL QUERY="GetCustomers" FROM="[EMAIL PROTECTED]" TO="#EMail#" SUBJECT="Contact Info Verification" Dear #FirstName# - We'd like to verify that our customer database has the most up-to-date contact information for your firm. Our current information is as follows: Company Name: #Company# Contact: #FirstName# #LastName# Address: #Address1# #Address2# #City#, #State# #Zip# Phone: #Phone# Fax: #Fax# Home Page: #HomePageURL# Please let us know if any of the above information has changed, or if we need to get in touch with someone else in your organization regarding this request. Thanks, Allaire Customer Service [EMAIL PROTECTED] /CFMAIL Regards, Howie - Original Message - From: George Loch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 26, 2000 11:25 AM Subject: Custom tag for generating email Does anyone know of a tag that would allow for the creation of an email message that is automatically generated and sent to a DB of email addresses. It is like a weekly newsletter that let's people know what's new for the week. Thanks George Loch -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Custom tag for generating email
Thanks to everyone for your replies. I have acutually done a little on this. Setting up the email to a DB of users has turned out to be easier than I realized. The challenge is that I am also including dynamically-generated content in the email. In order to do this I am doing a table join between a membership table and a content table. In the content table are a bunch of articles and each article has a date property assigned to it. What I am tring to accomplish is to grab the articles for that week in a query and put the info in the email. So, how do I use the Date function to create situation like: cfset todays_date = #Dateformat(Now(), "mm/dd/") cfset endofweek_date #Dateformat(Now +4(), "mm/dd/") Select stuff, from members,content where content_date BETWEEN todays_date and endofweek_date Ideas? Thanks George Loch -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.