A recent issue has information about sending reminders to Outlook from Access.
"If you have a table that contains a date field, and you want to make sure that something happens on that date, one way is to create an Outlook task with a reminder that will pop up on the specified date; you can even use the Outlook reminder to create an email message that will be sent on the specified date.
This article will show how to create an Outlook task from Access VBA code, and send an email message when the task's reminder fires."
The file is located on Helen Feddema's site. Access Archon Scroll down to #126
The zip file contains the WAW article, in Word format, plus the supporting file.
Helen Feddema has been working with Word since v. 1.1, Access since the beta of v. 1.0, and Outlook since the beta of v. 8.0 (that's where Outlook started its version numbering).