automatically sends outlook message when certain date is reached

  • Thread starter Thread starter Sei
  • Start date Start date
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.
 
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Automatically update all future dates when earlier date is entered 3
Please help: Send object when argument satisfies 1
Access and Outlook Reminders 2
Create Groupwise Reminder for Access 2
microsoft office access can't send this e-mail message 0
Expiration Date Automatic Update 1
insert date automatically when clicking a check box 3

Back
Top