|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 4th, 2005, 09:31 AM
|
|||
|
|||
|
you're average email alert procedure?
So, i'm fairly new to coldfusion and totally new to email alert systems.
I'm familiar with cfmail though. so... What is the procedure for making a system where, if the back end user selects one of two options (live or offline) and clicks save, a bit of cfmail emails everyone in a database of email addresses? We don't want to have one email sent with every recipent as a CC, it must be individual to each recipent. So it will need to (in the to: part) loop through the whole cfmail script changing the to: address each time until the database list is exhausted. Any help would be grand. Thanks.
|
|
#2
August 4th, 2005, 10:00 AM
|
|||
|
|||
|
Look at the query attribute of the cfmail tag.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
#3
August 5th, 2005, 04:41 AM
|
|||
|
|||
|
so... just to confim.
We are running coldfusion 4.5, so does the query attribute work on that version? I found this code on the live docs... so, is it really this simple: Code:
<cfquery name="BetaTesters" datasource="myDSN"> SELECT * FROM BETAS </cfquery> <cfmail query="BetaTesters" from="beta@MyCompany.com" to="#BetaTesters.TesterEMail#" subject="Widget Beta Four Available"> To all Widget beta testers: Widget Beta Four is now available for downloading from the MyCompany site. The URL for the download is: http://beta.mycompany.com Regards, Widget Technical Support beta@MyCompany.com </cfmail> Thanks!
|
|
#4
August 5th, 2005, 06:17 AM
|
|||
|
|||
|
it's ok, i just tried it, and it works a treat.
thank yoooo
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > you're average email alert procedure? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
