Send email reminders to complete Tasks based on Due dates

  • Thread starter Thread starter Minal
  • Start date Start date
M

Minal

Hi
I have a Table with the following feilds

No. - Autonumber
Task# -Number
TaskAssignedTo - Text
TaskDes. - memo
DueDate - Date
CompletedDate - Date


The database is on the intranet server with multiple users logging on.
I have put user level security.

All information is entered Via a form. I have a Switchboard that opens
first to help the user to navigate to the various forms.

I want the database to automatically send and email reminder to the
person (TaskAssignedTo) to whom the task has been assigned 1 week prior
to the DueDate with the, Task#, TaskDes (Task Description), And DueDate
in the body of the message
And the subject line "Please complete the task by the due date"

Can this be done? If yes can some one guide me as to how step by step.

Thanks in advance

Minal
 
Yes, it could be done. To do this you'd have to run a query against the
database that queries tasks for one week hence, either daily or weekly
(using the DateDiff function in your query comparing with task due date -7).
Once you have this information in a query with a parameter feed to the query
of the current date, you could loop through the resulting recordset and send
emails to the respective individuals.

You can do this a couple of ways. You could:

a.) Do it via a separate front end database opened on your workstation that
is attached to the intranet database, looping through the recordset and then
using either the SendMail method or by programming Outlook from within
Access.

b.) Do it via a web based interface, that opens the recordset using ADO on
an ASP page use the web server's mail capabilities (using either CDONTS,
which is fairly simply to program), or another mail function on a windows
server like CDOEX.
 
Back
Top