Unanswered: Creating a system that will send emails to users
I am what you would call an amateur when it comes to making a database. But I'll jump into it...
I work for a company and would like to create a database using their current contacts/contact information based on phone records.
There is currently a solid amount of contact information available to start with but to encourage my fellow employees to keep the database up to date, I'd like to have the database tied into the phone records. Any time an employees receives a call or makes one, the record will be noted and double checked through the database to see if there is a record already for this number. If there is not I'd like to have an email sent to the employee based upon his/her extension that would ask them to add the contact to the database.
Is this at all possible using microsoft access? If so, how would I go about doing this?