Auto email when due date is due

[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,

 

[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.

 

[Tony Toews [MVP]]

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/