date field that will trigger sending an email

[CSMCD]

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?

 

[Jeff Boyce]

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