asked on How to add, remove and edit MS Outlook Tasks and Calendar Items using MS Access
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:
http://www.experts-exchang
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.)
I found the following article helpful:
http://www.experts-exchang
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.)
Microsoft AccessMicrosoft Development
Last Comment
Oliver Wastell
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You could save the EntryID in Access when creating your task to be able to retrieve it
See limitations
http://msdn.microsoft.com/en-us/library/office/ff868464(v=office.15).aspx
See limitations
http://msdn.microsoft.com/en-us/library/office/ff868464(v=office.15).aspx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Rgonzo: your last post looks promising. I'll give that a try before coming back and awarding points. Thanks.
My Working with Outlook ebook has many examples of working with Outlook items of various sorts from Access (it includes sample databases). I can't give a direct plug here, but you can find it on the Office Watch Website.
There are also several free code samples on the Code Samples page of my Website:
http://www.helenfeddema.com/Code Samples.htm
There are also several free code samples on the Code Samples page of my Website:
http://www.helenfeddema.com/Code Samples.htm
ASKER
Thanks for the help Rgonzo and sorry for the delay in the award.
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?
Thanks