Send Automatic Emails Based on Date

[Shannon3778]

I need to create a report that goes out to specific individuals (emails are a field in my table) when a specific date (also a field in my table) comes up. I've created a report that I can run and a form that allows me to put date ranges in, but that report compiles all of the individuals into one report and I need only the info specific to the individual to go out AND I need it to go out automatically... any ideas?? I'm attaching a copy of the database. Basically, using the Tbl_PIPTracker, I need the emails to go out to the manager email, the supervisor email, and cc another email (that I can fill in later) when the date of the 30 day field comes up and when the date for the 60 day field comes up....

 

[Shannon3778]

Ok... so it won't allow me to attach the Db... guess it's too big. Any ideas or help to having the auto email go out to the specific email address when todays date = the date in a field in the table would be great!!:banghead: