Email Ticklers by Flagging a date

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

I am making an appointment database and want it to shoot
me an e-mail early the day the appointment is due. How
do I have Access use Outlook when something is due by
date? I know I start with a macro to hit a date, but
what commands would I use to have Access automatically do
this at say 12AM midnight every day? I know I could use
Outlook calendar but I like using Access to hold other
linked data Outlook is not suited for.
 
You can use the Access SendObject command to send an e-mail.

Getting Access to do something automatically at a given time is a bit
harder.
Every form has a timer, which can be used to execute code (or macros, if you
insist) at a regular interval.
So you could check whether midnight has passed; if it has, execute your
SendObject.

A couple of caveats:
You'll need to work out a system so that SendObject is only executed
once each day.
Remember that none of this will work if your Access database (and the
form with the timer you're using) aren't left open at midnight.

HTH
- Turtle
 
Back
Top