send reminder or email automatically

[Ran S]

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!

 

[Vincent Johns]

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!

You can use the "SendObject" action in a Macro (or invoke it in a
Module) to generate an email. Since this can be done under program
control, you can determine when and to whom each object (such as a
Report) is to be emailed.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.