Easy like pie ;-) 1) schedule a task to run at the desired intervals 2) task checks for all members that haven't yet recieved todays mailing 3) send mail to the first X members that have yet to get todays mailing 4) update the flag for those getting sent the mailing 5) clear out all flags at midnight and stat fresh
So you'll need to alter you tables to contain a boolean (yes/no) column (called Mail_Sent). You'll also need to pick a decent interval (not so close that the first task has time to complete). To pick the number of folks to send to at each interval I'd do some simple math...total number of members divided by number of intervals gives you number to send each interval (you can do this dynamically of course as your membership fluctuates). That's the broad brush stroke for ya...hope it helps Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com/54 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184452 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
