QUOTE(cumupkid @ 15 Apr, 2008 - 07:06 PM)
Any suggestions on how to send emails to a group of people in a MySQL Database with Coldfusion.
Also, want to BCC these emails , or something to hide the email address from all the recipients.
AND... I still haven't figured out how to make database output tables have two columns...Anyone?
Thanks in advance
Joe
Write a query to select all the information (email addresses, names, etc.) from the DB. Then use
CODE
<cfoutput query="YOUR QUERY">
and nest your CFMAIL tag between the CFOUTPUT tags. This will loop through all selected DB records and perform whatever action you specify between the CFOUTPUT tags (such as CFMAIL).
You can use the same technique to create multi-column tables by placing your table structure between the CFOUTPUT tags instead of the mail tag. Be sure to only put the tags you want to repeat between the tags. For example, don't put your TABLE tag in the CFOUTPUT, only your TR or TD tags that you want looped.
Hope that helps
15 Apr, 2008 - 07:06 PM
|