We are looking at moving from Access to SalesForce due to SalesForce's ability to track Emails. My boss wants to know how feasible it would be for Access to keep track of Emails in the same way.
Our Database is structured with One company having many Locations; in turn, each location can have many staff.
A Communications Table/Form stores details of Communications with staff in each location. Therefore, when a User sends an Email, would it be possible for Outlook to . . .
1) Cross-check the Email address in the TO Field against the Staff Table in Access.
2) If the Email address exists in Outlook, retrieve the LocationID, StaffID from the Location Table.
3) Make a Temporary Table in Access with the Date; LocationID, StaffID, SenderID, MessageTypeID, and Subject
4) Append the above fields to the Communications Table.
This sounds wildly complicated, but I've looked through the Internet and these Forums, and because of the ability of Outlook and Access to 'speak', I thought it might be feasible, but just how easy it would be or how much programming would be involved is beyond me as it's not simply sending a Task or Email from Access but rather querying Access and then returning Data from Outlook to Access.
Thanks in advance for any guidance--it's greatly appreciated, as always.