Tuesday, August 28, 2007

Integrating Access Contacts with SharePoint and Outlook

The Access Team Blog has posted VBA code on using the new Add From Outlook feature in Access 2007 to work on a custom contacts table. This feature uses the same mechanism to determine that a table is a contact table, but more than that it needs to know how to map fields in your table to those in the Outlook contact store. This code will take any table, and make it into a contacts table. You just add the code to your solution, then update the table name and field names to reflect the fields in your custom contacts implementation, and run it.