If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
date field that will trigger sending an email
Access 2003 - how can i create a date field containing a future date such
that on that date, an email with a standard, fixed subject line & no body text will be automatically sent to the email address in the 'emailaddress' field; also, the subject line of the email should be another field on the form. i'm trying to add these fields to the 'contact management' template so the user can get a reminder to make a follow-up call to the contact entry. our email system right now is lotus notes, but will be changed over to outlook in 2008. is this possible? -- CSMCD |
#2
|
|||
|
|||
date field that will trigger sending an email
You'll need to write an event procedure that "looks" at the records and
sends the emails. By the way, if you ONLY send when that date field is "today", and if that date field's value falls on a day the application isn't running, you WON'T be sending that person an email. You'll want to think it through a bit more -- sending only on that date won't handle all the situations unless you can guarantee that the application will be run by someone on EVERY day in that field. Regards Jeff Boyce Microsoft Office/Access MVP "CSMCD" wrote in message ... Access 2003 - how can i create a date field containing a future date such that on that date, an email with a standard, fixed subject line & no body text will be automatically sent to the email address in the 'emailaddress' field; also, the subject line of the email should be another field on the form. i'm trying to add these fields to the 'contact management' template so the user can get a reminder to make a follow-up call to the contact entry. our email system right now is lotus notes, but will be changed over to outlook in 2008. is this possible? -- CSMCD |
Thread Tools | |
Display Modes | |
|
|