You can "cfloop" on a list
<cfloop list="#ValueList(GetEmails.EMail)#" index="oneName">
<cfmail to='[EMAIL PROTECTED]'
from='[EMAIL PROTECTED]'
subject='newsletter'
bcc='#oneName#>
#Message#
</cfmail>
</cfloop>
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 3:07 PM
To: CF-Talk
Subject: bcc and lists
How do I retrieve sets from a list so as to loop through the list and send
groups of emails in the bcc field rather than the whole list at once or only
one at a time?
<cfset MailList = ValueList(GetEMails.EMail)>
<cfmail to='[EMAIL PROTECTED]'
from='[EMAIL PROTECTED]'
subject='newsletter'
bcc='#MailList#>
#Message#
</cfmail>
Thanks,
Sebastian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists