First of all... 1800 is NOT that many emails. Id consider looking for a new host if you are paying :)
But... You could write a page that sends 3 or 4 emails or however many you want at a time. As you select the emails and send them, flag them as 'sent' in the database so they arent selected again. Then put a meta refresh on the page for 10 - 15 seconds or however long you want to wait before sending the next batch. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Stephens, Larry V [mailto:[EMAIL PROTECTED] Sent: Thursday, November 23, 2006 4:37 PM To: CF-Talk Subject: Timed cfmail I need to send ~1800 unique messages (i.e., I can't use a listserv). I can't send them all at once (so my host site tells me) because it would clog their mail system. To avoid sitting here and clicking a link 1800 times I thought I would do it with code. <cfquery ...> <!--- get my data ---> </cfquery> <cfoutput query="xxx"> <cfmail .....> Message content </cfmail> ---- time delay to stop iteration of cfouput ---- </cfoutput> Or something like that. I tried some code using DateDiff and that didn't work. I tried inserting a javascript timer function and that didn't work. Could be I just didn't do it right - but can anyone offer a suggestion (to solve the problem within the parameters of not switching host sites, etc.)? Thanks. Larry V. Stephens Indiana University Office of Risk Management [EMAIL PROTECTED] 812-855-9758 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
