send appointment warning via email

[DM]

Hi,

Is it possible to set up an automatic email warning that
is sent out 30 days prior to dates held in an Access date
column. Could it be linked dynamically to Exchange or
Outlook?

It should work even if Access is not opened by a user. I
do not have VB so must work within Access's tools if
possible.

Thanks for your help,

 

[MacDermott]

AFAIK you cannot have an Access application which performs anything on its
own without Access being open.

 

[Alastair MacFarlane]

DM

The only way I would do this is to add a shortcut to the
startup of your computer, open a separate database (with
linked tables), create an AutoExec Macro which runs a
dcount function to identify whether there are any
appropriate records, then uses Outlook Automation code to
send reminders if appropriate.

If you need help with them I am sure other members of the
group can help. I have done this type of thing before and
it works well!

Good luck,

Alastair