Skip to content

Synchronizing Access and Outlook

How to synchronize Access and Outlook – a more advanced lesson.

Q:  Jim Brooking writes that he is trying to use my Code Sample #49 for synchronizing Access and Outlook contacts, but it doesn’t do all that he wants, in particular two-way synchronizing.

A:  My Code Sample #49 dates from about 10 years ago, when it was the best that could be done with Access 97 and Outlook 97 or 98.  In 2007, it is not exactly state-of-the art (though still useful for some tasks).

In my latest book, Access™ 2007 VBA Bible For Data-Centric Microsoft Applications, I have a chapter on Synchronizing Contacts which deals with this problem in a more advanced manner, with two-way synchronization (see the Used & New link on the Amazon US book page to order an autographed copy).

About this author