Have a scheduled task that calls your mailing script every xx minutes. The mailing script selects to the top 100 people not yet mailed and mails them, and then marks those people as mailed.
Russ -----Original Message----- From: Stephens, Larry V [mailto:[EMAIL PROTECTED] Sent: 23 November 2006 21:37 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:261584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
