Just build a list of email addresses first.
Ie
<cfset emailTo = "" />
<cfloop query="users">
<cfset emailTo = listAppend(emailTo, users.email, ";") />
</cfloop>
<cfmail
to="#emailTo#"
Regards
Dale Fraser
http://dalefraser.blogspot.com
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of blueyoda
Sent: Thursday, 31 May 2007 12:46 PM
To: cfaussie
Subject: [cfaussie] CFMAIL sending to multiple addresses through the query
Does anyone know how to send 1 email through cfmail with multiple
addresses in the cc field.
I have a query named USERS and need to cc all the users from this
table but I'm getting 1 email to each CCed user and multiple emails to
the To address.
<cfmail
to="#varables.my_Email_Address#"
query="USERS"
cc="#USERS.SB_USER_EMAIL_ADDRESS#"
from="#varables.default_email_address#"
subject="#form.Subject#">
help
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
