Automated email notices based on specific dates in Access

S

Sheila Brown

I would like to have Access 2003 send me an email notice when a specific date
in a table is approaching. For instance, when the expiration of a lease
agreement is approaching. Is this possible and how would I do it?
 
J

james.igoe

Here's a link from my website, the code adapted from someone else, that
I used to shutdown an Access database at a set time, but can easily be
used to send reports at a timed interval.

Times: http://code.comparative-advantage.com/download.php?RecordID=73

Also, I have code on my site that can be used to generate Outlook
e-mails, as well as Excel files from queries and/or reports.

Outlook:
http://code.comparative-advantage.com/download.php?RecordID=24

Excel export:
http://code.comparative-advantage.com/download.php?RecordID=8


James Igoe

[email protected] || http://code.comparative-advantage.com
 
S

Sheila Brown

Thanks a bunch! You are a lifesaver!

[email protected] said:
Here's a link from my website, the code adapted from someone else, that
I used to shutdown an Access database at a set time, but can easily be
used to send reports at a timed interval.

Times: http://code.comparative-advantage.com/download.php?RecordID=73

Also, I have code on my site that can be used to generate Outlook
e-mails, as well as Excel files from queries and/or reports.

Outlook:
http://code.comparative-advantage.com/download.php?RecordID=24

Excel export:
http://code.comparative-advantage.com/download.php?RecordID=8


James Igoe

[email protected] || http://code.comparative-advantage.com
Click to expand...
 
Top