>I think when you say "before the event" that you are no longer talking about >delaying the email, but scheduling WHEN the email should be sent.
Correct, but see below... >In that case you are looking at event scheduling and it could be something as >simple >as a scheduled task, or you could get rather complex by leveraging Quartz (a >java scheduling engine). > >HTH, >Rich Kroll However, I have over 200 sites with more coming, each with a separate DB. Should I loop over every DB every 15 minutes? Wouldn't that be system resource intensive? >Easy. Set up a CFSchedule to run later and put the email info into a >table that the cfschedule pulls from and makes your emails. Yeah... a central DB that the individual sites INSERT INTO if a scheduled email is wanted, which CFSchedule pores over every 15 minutes to execute. Store the From, To: list, etc. I was hoping there'd be a way to save an email file to the queue folder and have the SMTP service kick it when it was ready. That would be sweet. Maybe put this on the Adobe wish-list? A CFMAIL parameter that declares when the email should be sent? Mik >Mik Muller wrote: >> Hey all, >> >> I've been wondering about delayed sending of email. What would the best way >> to, for example, not send an email at the moment an event is posted to a >> site, but, say, 12 hours before the event. How would YOU do it, using CF7 >> and IIS / SMTP. >> >> Thanks >> >> Mik -------- Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
