Email Alerts from MS Access 2007

[Ericksonclan]

I've designed a database for the tracking of employee demographics, required
initial and re-occuring paperwork, one time and ongoing training, and
disciplinary actions. I currently have it set up that each month the user
pushes a button and a report prints out showing who in the next month has
training that needs to be re-completed and also the annual or bi-annual
paperwork that needs to be completed. However, now the user wants Access to
send her email alerts whenever a due date comes up 60days out. Is there a
way to set Access 2007 to automatically send out emails with the employee's
name and what is required in the next 60days?

 

[SnowWhite]

I am trying to accomplish the same task and I am struguling in the part of
adding the email address directly into the email inbox. In my case, I have
for instance 20 letters that need to be send to clients. I created a macro to
append each letter into the inbox directly however I cannot figure it out how
to put also the email address into the inbox at the same time. So in the mean
time, I have an option to open the table containing the email address in the
order the reports are going oito the inbox.
If someone has an idea on how to read the email address that refers to the
first letter and send direcly to the email inbox will be greatly appreciated.
regards, Monica