The universal objective of any CRM system however, is to provide a “single-view of all customer-related information to everyone in the organisation".
As will be seen later, this limitation can be overcome automatically by synchronizing your Outlook Contact and E-Mail data to a relational database like SQL Server.
Unfamiliar Data Structure Outlook/Exchange folders are an unfamiliar data structure for more databases, report writers, etc.
Even Microsoft’s own low-end database product Access has difficulty linking to an Outlook or Exchange folder in such a way that all fields (including custom fields) can be viewed/manipulated.
If the home page is in a non-default data file (such as a secondary mailbox), you'll need to set the Non Default Store Script value too.
Removing the folder home page capability "broke" a lot of applications, including Business Contact Manager and Dynamics CRM.MX-Sync can synchronize all 5 types of Outlook folders to and from a SQL Server database, namely Contact-type folders, Calendar, Task, E-Mail and Journals folders.It supports Outlook custom fields, so key ID fields that exist in the SQL tables can be synchronized to custom fields in the corresponding Outlook folders so that the relationships between the tables in SQL can also be maintained in the Outlook folders.go to top of page There are many situations where one might want to synchronize data between Exchange Public Folders and a SQL database.On the other hand you may have data in a SQL Server database that you want to interact with or update using Outlook.But synchronizing this data to and from a SQL Server database overcomes these disadvantages and maximizes the strengths of both platforms.go to top of page This article was written by Brian Drury, founder of Exchange Wise ( and the architect of MX-Contact ( a CRM, Contact Management and Sales Automation System for Microsoft Outlook.That is, these same ID fields can be used as linking fields between the Outlook items, or used to build standard Outlook object links between items.go to top of page If youre looking for an application to assist you with managing a contact list of some kind, whether it be customers, prospects, members, suppliers or whatever, check out MX-Contact.This article looks at synchronization of Outlook data from Exchange Server Public Folders to a SQL Server database and vice versa, namely SQL Server to Outlook/Exchange synchronization.We look at typical scenarios where you might want to synchronize your Outlook data to and from a database like SQL Server, and the associated benefits.