send email OR reminder automatically

A

Anna

Hi,

In my MS access database I have fields due_date, status, Analyst. And I want
to generate a reminder message automatically in outlook to everybody OR email
automatically and should start giving reminders 5 days prior to the due_date
to each one of the analyst for whom projects are still due?. And it should
remind everyday the projects which are due, first thing in the morning when
one opens up his/her outlook, untill its done (untill status
field='complete'). Everybody has different dates for different projects
therefore it should send reminder to everyone in the Analyst field for whom
projects are still due?

I would appreicate your help.

Thank you so much!
 
Top