<div>
This is not an easy task. &nbsp;In the sample database for my last printed book, the Access 2007 VBA Bible, I did synchronization between Access and Outlook contacts (for Office 2007). &nbsp;Since Access is a relational database, with one-to-many relationships between companies and contacts, and contacts and phones and IDs, this involved denormalizing the data when moving Access data to Outlook, and normalizing the Outlook data when moving it to Access. &nbsp;Lots of code there.
</div>


This is not an easy task.  In the sample database for my last printed book, the Access 2007 VBA Bible, I did synchronization between Access and Outlook contacts (for Office 2007).  Since Access is a relational database, with one-to-many relationships between companies and contacts, and contacts and phones and IDs, this involved denormalizing the data when moving Access data to Outlook, and normalizing the Outlook data when moving it to Access.  Lots of code there.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have an outlook configured with exchange but I need to manipulate the contacts info, so I thought could be possible with ms access 2013 but I can't find a solution to do it. I need to create some queries in access with the contacts info, delete duplicate records, create query with all users that have an email on the field email, and some other things, but I need to keep updated my outlook contacts info.<br />
<br />
Any idea? some guidelines or a place where can I find info about?<br />
<br />
There are around &nbsp;15 thousand records on the conacts folder, so do it one by one is complicated.<br />
<br />
Thanks
</div>
</div>


Hello,

I have an outlook configured with exchange but I need to manipulate the contacts info, so I thought could be possible with ms access 2013 but I can't find a solution to do it. I need to create some queries in access with the contacts info, delete duplicate records, create query with all users that have an email on the field email, and some other things, but I need to keep updated my outlook contacts info.

Any idea? some guidelines or a place where can I find info about?

There are around  15 thousand records on the conacts folder, so do it one by one is complicated.

Thanks

synchronize outlook contacts with ms access 2013

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.