>- see footer for list info -< I did this using a schedule. I had 1 table with the emails / clients Another with the mail shot details to go out. A 3rd table called mails sent with the clientid and mailshotid together, and sent them off at 100 every 2 minutes using a:
SELECT TOP 100 FROM Emails WHERE EmailID NOT IN (SELECT EmailID FROM MailsSent WHERE MailShotID = 5) <cfloop><cfmail></cfmail><cfquery>update mails sent table</cfquery></cfloop> Any use to you? Allan Damien Gallagher <[EMAIL PROTECTED]> wrote: >- see footer for list info -< Hi, I need to create a function to send an email newsletter. The code will loop over the list so that each mail is sent to just one address. I also want to send the emails out in batches, with a short pause between each mail sent, and a longer pause between each batch. What would be the best way to do this in CF? Thanks, D _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< --------------------------------- For ideas on reducing your carbon footprint visit Yahoo! For Good this month. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
