automatically sends outlook message when certain date is reached

S

Sei

My database includes a field called "suspenseDT" - a future date where
user needs to take additional action. What i'm trying to do is to
configure access to send out a message automatically to a certain user
when suspenseDT = now(). Kind of like a reminder message. Any idea
how I could accomplish this? Thanks

BTW, I'm using Access 97.
 
G

G. Vaught

Don't use now() as it includes time info hour min sec. If you try to set a
condition it will always return false as you need to know what time now
returned in addition to the date and the time changes as time passes. Use
Date(), which returns only the date.
Are you wanting to popup a dialog message box, send an email. How do you
want to notifiy the user?
 
A

azu_daioh

I want to send a message to the lead of a particular project. It'll
just be a simple message including the projectID and the suspenseDT
fields. Thank you.
 
Top