I have a database application where we are tracking project information for a system that we develop and import data for. This database that I created is tracking how much time it takes us to load data into another system, the stats like # of records, etc.
We assign a data load to a particular employee by a field called Assigned To. I have a combobox with all of the employees working on this project.
How can I setup an email message that is sent when the person is selected to notify them?
We are using Exchange Server. They are in the GAL.