Re: delayed email response
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61937
interpreted = N
texte = Hi Paul, Pretty simple really. One possible suggestion would be: - Append the information regarding the 2nd email to a database; a SKU number (makes it easier to clear old records), EMAIL_DATE, EMAIL_TIME, EMAIL_FROM, EMAIL_TO, SUBJECT, EMAIL_BODY and WAS_SENT. - Have a template that has a simple search for a date/time in the range that you need (current date, time => current time+X number of hours) and neWAS_SENTdatarq=T. - All found records are in a sendmail context that has the EMAIL_FROM, EMAIL_TO, SUBJECT and EMAIL_BODY dynamically inputted from the database. - After the sendmail loop, you flag the WAS_SENT with a "T" variable. You then set up a trigger to hit this page every hour, or you manually hit the page once a day (if you just need to send out the days orders worth of email notices all at once). It's up to you if you want to then add a delete context to remove all WAS_SENTdatarq=T records or just kill the EMAIL_BODY portion in a replace so that you have a record of outgoing emails, or remove nothing and just let this database build up. That's just one possible solution I reckon.... GJK At 06:56 AM 5/6/2005, you wrote: >Hi > >I need to send out an email from the storebuilder several hours after the >confirmation email, is thsi possible > >When someone orders at the moment the confirmation goes out immediately, I >would like to send a second email some time later, how would I do this? ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Paul, Pretty simple really. One possible suggestion would be: - Append the information regarding the 2nd email to a database; a SKU number (makes it easier to clear old records), EMAIL_DATE, EMAIL_TIME, EMAIL_FROM, EMAIL_TO, SUBJECT, EMAIL_BODY and WAS_SENT. - Have a template that has a simple search for a date/time in the range that you need (current date, time => current time+X number of hours) and neWAS_SENTdatarq=T. - All found records are in a sendmail context that has the EMAIL_FROM, EMAIL_TO, SUBJECT and EMAIL_BODY dynamically inputted from the database. - After the sendmail loop, you flag the WAS_SENT with a "T" variable. You then set up a trigger to hit this page every hour, or you manually hit the page once a day (if you just need to send out the days orders worth of email notices all at once). It's up to you if you want to then add a delete context to remove all WAS_SENTdatarq=T records or just kill the EMAIL_BODY portion in a replace so that you have a record of outgoing emails, or remove nothing and just let this database build up. That's just one possible solution I reckon.... GJK At 06:56 AM 5/6/2005, you wrote: >Hi > >I need to send out an email from the storebuilder several hours after the >confirmation email, is thsi possible > >When someone orders at the moment the confirmation goes out immediately, I >would like to send a second email some time later, how would I do this? ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
re:check boxes (1997)
Possible Bug in 2.0b15.acgi (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
WC TableGrinder (1997)
WebCAT has the devil in it! (2003)
WebTV, IPAddress, Cookies, IDEAS?? (1998)
foriegn characters and webcatalog (1997)
So what ya working on? (or have you completed?) (2004)
Merging LineItems (2003)
convertchars and case? (1998)
hiding return characters (2000)
Deleting Orders (1997)
Authenticate Questions (2003)
is your webDNA site 'froogle' ready ??? (2003)
[WebDNA] Still no .png image sizes (2015)
Clean Code: Rules for inserting keyboard returns? (1997)
Setting up shop (1997)
page not found redirect (1999)
Adding Text (2000)
WebCat cannot handle compatible search parameters? (1997)