Thanks
everyone for getting me to think in another direction. It's great learning some
new everytime.
Arun.
-----Original Message-----
From: charles arehart [mailto:[EMAIL PROTECTED]]
Sent: April 10, 2002 12:56 AM
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] Bulk EmailWell, Is there any reason why you want to create a single email with all 680 recipients? Why not instead loop over the contactlist (CFLOOP LIST="#contact") and send out 680 different emails?The limit of 40 you refer to was indeed a limit in the number of recipients for a single message. There's no limit on sending out x individual messages to a single or small number of recipients--other than the impact on the mail server you're going to be hammering away at (in your case mail.server.net). Then again, plenty of folks send out thousands of messages at a time in CF apps, so this really isn't too big a deal.Finally, if you're creating that contactlist variable by way of some other loop over a query, you can simplify things by instead simply using the QUERY attribute in the CFMAIL tag and naming the column that has the email address for each record in the TO (or in your case the BCC) field. See the CFML reference for more on this powerful and often-underutilized option./charlie-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Arun Persaud
Sent: Tuesday, April 09, 2002 7:43 PM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] Bulk EmailI need to send out 860 emails using CFMAIL. Works fine with a small list. I'm not sure, but I think I read somewhere that CFserver can handle something like 40 at a time. Any suggestions on how to send this huge amount out?I'm using CFserver 4.5 and SQL database and a company mail server.The following is the code I'm using to send it out to the list without every recipient being able to see each other (BCC).<CFMAIL
TO=" "
BCC="#contactList#, [EMAIL PROTECTED]"
FROM="[EMAIL PROTECTED]"
SUBJECT="#form.subject#"
SERVER="mail.server.net"
TYPE="HTML">
#form.message#
</CFMAIL>Thank you.Arun.
