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?