Chris,
I had to create a mail solution similar to this once. I couldn't put
multiple email addresses in "to" or "cc", and I couldn't use "bcc". I had to
loop over the cfmail tag to send each message. It was for a list of about
300,000 people, so I had to limit the number of emails that went out at a
time. I think I did about 30 at a time. The first thing I did was query the
different email address sources and put them into a "this mailing" db table.
Then I did a "SELECT TOP 10 addresses" and looped over these using CFMAIL
(MUCH faster to use TOP in SQL Server. Cut down the mailing process by
DAYS). I then deleted these records from the database and used a meta tag to
refresh the page every 10 seconds or so. This solution didn't put too much
strain on the CF server or the email server. They had a lot of other traffic
too, so if you've got some more available processor power you could send out
many more in each batch.
HTH,
Jason
----
Jason Aden
Allaire Certified Developer
[EMAIL PROTECTED]
www.wwstudios.com
> -----Original Message-----
> From: Chris Martin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 6:10 PM
> To: CF-Talk
> Subject: The CF Mail Server
>
>
> Hello everyone.
>
> I am working on an application that manages private groups membership, and
> one of the function the client wants included is the ability for an
> administrator to write an email, then submit it to all the members of a
> given group. What I want to know, is will the built in cf mail stuff be
> able to handle it if I query the DB, and loop over each email address with
> the message? I imagine it wont be a problem for a group with 10 members,
> but for a group with 55 or 60? I have no desire to bring the server to a
> grinding, crashing halt. Can anyone share some ideas?
>
> Thanks,
>
> Chris Martin
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
