Auto email when due date is due

A

Access User 09

Hello,

I've created a very simple DB to log customer complaints, nothing
complicated except the due date calulation which is due 30 days from the date
that the complaint was documented and each complaint has a number assigned as
the primary key. I have email address of the person responsible. My question
is can someone help/show me how to auto generate an email reminder (internal
only) to the person responsible when the due date is due for that issue
please?

Thank you,
 
A

AFSSkier

The simplest way is to use the Window Scheduled Tasks.

1. Create an Access macro for you task. Use the SendObject "Report" action.
In an unbound Report, "Type your alert message". Access needs something to
email.

2. Create a shortcut to the macro on your desktop or folder. Right click on
the macro icon or drag it to the folder.

3. In the Windows Control Panel there is a "Scheduled Tasks"

4. Add Scheduled Task. Schedule the task for Daily, Every 30 days or
Monthly on 1st Monday, etc.

As long as the PC is running, the task will run. Access does not have to be
open. However, Access 2000 & newer will prompt the user that a program is
trying to send an email. All this user has to do is "Allow" the email to be
sent.

Also in my scheduled macros, I like to begin the macro with SetWarnings (No)
& end with Quit to exit Access after the task is complete.
 
T

Tony Toews [MVP]

Access User 09 said:
I've created a very simple DB to log customer complaints, nothing
complicated except the due date calulation which is due 30 days from the date
that the complaint was documented and each complaint has a number assigned as
the primary key. I have email address of the person responsible. My question
is can someone help/show me how to auto generate an email reminder (internal
only) to the person responsible when the due date is due for that issue
please?

Using VBA code, with a query which looks at the tickler date based on
todays date. I.e. <= Date(), set a flag in those records as "about
to send emails", loop through the recordset to send the emails, update
the flag as "sent emails", and a sent date. Repeat tomorrow.

Is this a database they would open up daily? If so you can do
something similar with query behind a form which is displayed on
startup.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 

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

Top