I have done this with CFMAIL for a recruitment site with over 20,000 emails, and yes, in pre-MX days it did occasionally cause problems ( I believe MX is more robust but have retained the same functionality ). So I did exactly what you mentioned, write the email text to a database then have a scheduled emailer looking into this table and sending, say, 50 emails every 5 seconds?
You can then use this to log all emails sent without parsing out the mail log, which is nice. -----Original Message----- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 29 October 2003 12:11 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Sqillions of Emails Lo all, If I have a DB with, say, 5,000 addresses and I want to send an email to each of them .. would it be advisable to do this through good old CFMAIL. I've never had to ever send this many emails in one go so I'm curious as to how best to send them without breaking the mail server and I'm sure this number may double in the future. I would have thought breaking them up into batches of 100 or so might do the trick with maybe a delay between the sends but Im sure you guys must have done something similar so its best practices territory again :�) Thanks in advance for any help :�) Regards Stephen Pope Web Developer Eduserv Internet managed hosting and development _____ [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> tel: +44 (0)1225 474300 fax: +44 (0)1225 474301 http://www.eduserv.org.uk/internet/ _____ Eduserv Internet is a service of Eduserv Technologies Ltd DISCLAIMER: This e-mail is confidential and may also be legally privileged. If you are not the intended recipient, use of the information contained in this e-mail (including disclosure, copying or distribution) is prohibited and may be unlawful. Please inform the sender and delete the message immediately from your system. This e-mail is attributed to the sender and may not necessarily reflect the views of the Patsystems Group and no member of the Patsystems Group accepts any liability for any action taken in reliance on the contents of this e-mail (other than where it has a legal or regulatory obligation to do so) or for the consequences of any computer viruses which may have been transmitted by this e-mail. The Patsystems Group comprises Patsystems plc and its subsidiary group of companies. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
