I would like to produce a CRM system in MS Access 2007 for multiple users. As part of the system I would like tasks and calendar items (planned visits to prospects) to appear in MS Outlook. I would like to be able to add, edit and remove these tasks and calendar items within the MS Access application and have them automatically updated in Outlook.
I found the following article helpful:
but this only creates the items so I'm not sure about editing/removing them from within the MS Access application.
What is the best way to go about doing this and how easy is it to do? (I'm very experienced with MS Access / VBA, but I have limited MS Office automation experience.)
Thanks for that. If I want to edit/delete a particular item originally created by the Access application (there might be several on the same due date) how would I do that?