Automated Email via Outlook? (Based on date)

[LyTseu]

Hello all,

I have a database I'm taking care of.'I was wondering if it was possible for the database to send email to me (for example) automatically?
Example:

Item 1 due date is in September 1, 2010
On september 1 can Access send an email automatically as a reminder (Your due date is due etc..)?

Thank you,
Ly.

[MMcCarthy]

Hi Ly

The answer is yes and No :D

You can add code to access to send an email. You can work out a way for that email to be triggered. However, for that to happen the database would have to be open.

Mary

[LyTseu]

Ah.. I see that's what I was expected. The database should be (ideally) on a daily base. How can I set this up? without reminding everybody that they need to check what is due today, but as soon as the database open it will automatically dispatch an email to a group of person via outlook.