Sending Emails through Access

Hi there,

This is my first post in the forum so I will try to explain the problem as well as I can. Now here is what I am trying to do. I have created an Access DB to keep track of different project estimates.

What I want to do is to create a form where I can go check off using the checkbox the estimators that have entered estimators and then send reminder emails to the ones that haven’t entered in their estimates yet.

So far I have created four tables,

1. ScopingMeeting (project ID, meeting ID and meeting date)
2. MeetingAttendee (MeetingAttendeeID, DeptID, AttendeeEmail, AttendeeName)
3. ScopingFunctionalDept (FunctionalDeptID, FunctionalDept, ManagerName, ManagerEmail)
4. MeetingAttendeeMM (AttendeeID, Meeting IDFK, AttendeeIDFK, Estimate (checkbox) )

Now I don’t know what code should be used to create this form where I can just select everyone who has entered their estimates and then hit a button to send a reminder email to everyone else including their dept manager. Any help would be greatly appreciated.

Thanks!

[1361 byte] By [Bostonian007] at [2008-1-9]