Certainly, but you will need the program to be open so that the code will
run.
There are 2 ways to do this.:
1. Use a scheduling program to open Access and have Access run a check for
the date and send the email if applicable.
2. Leave the Access app open, and poll it with the Timer event of a form.
You may have a problem with the Outlook current security settings which will
not allow email to be sent automatically. In that case, you may need another
email program. From Access, use SendObject with any default mail client, or
you can use the code on my website to send mail in Outlook.
http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
