I have created an Access database (version 2007) that is used and frequently updated by several staff members in the office. In addition to the updated records, there is a list of associated staff members for each record or type of records. In one field there is a frequency of activity listing (Ex.: weekly, monthly, quarterly, etc.) with a start and end date field.
We would like some type of automatic reminder system that looks in the proper field and automatically generates an email message to all staff members listed on the record to remind them to update the database for that record at a given time. We all use Outlook as the email system. Each associated user's email address is listed in a field on each record. Can this be done and if so, how. If possible, we'd like a cc: to also be sent to the group manager and supervisor.
A separate table listing the associated staff mamberss' names, email addresses, etc. can be made if you think that is best.
I will create any necessary fields to put on the form and make several separate email address fields rather than one, if necessary. Each record in the table has its own list of associated staff members who should be reminded of a due date.
Thank you for any assistance that you can give.