Tuesday, October 19, 2010

Importing Outlook Contacts into Microsoft Dynamics CRM Online using Add Contacts Wizard

The best option for importing existing Microsoft Outlook contacts into Microsoft CRM Online is to use built-in "Add Contact Wizard"

I came across a post explaining it in detail about the process. Thanks to "Harold Lee - Workopia, Inc."

Notes & Requirements:

- Microsoft Dynamics CRM Online account access

- Microsoft Dynamics CRM Online for Microsoft Office Outlook installed

- Appropriate user security roles to create CRM Contact and Account records


Steps to Import:

  1. First you need to open the Outlook Client and allow it to connect to CRM Online.

  1. Once connected, you should see the CRM toolbar loaded as well as the CRM menu, click the CRM menu to find Add Contacts to CRM


  1. The "Microsoft Dynamics CRM - Add Contacts Wizard" window should open and display the overview process of importing the contacts. Click Next to continue.

  1. The next window should allow you to select which contacts you wish to import as well as some options to change the parent, which is the Account that it will be associated with.

  1. There are two modes when you want to add contacts: an Advanced mode and the default Basic Import mode.


  1. Basic mode will be simple, just review which contacts you want included in the import and click next. Contact records will be created and also Accounts will be created if necessary based on the Outlook Contacts’ Company Name column.

    You will also notice different colors for each of the contact groups, green means that they have already synced into the CRM system and red usually means it is not able to sync (you can use this to troubleshoot). Yellow means there are mixed results with the multiple contacts. You can always import first and try to re-import to see the color scheme appear.

    With Advanced, instead of automatically binding existing or new Accounts, you can manually set an Account to associate it to. This means that by default it may not create the account for it, or bind it unless you set it yourself. Also you can choose to include Communication with the contacts which are selected by default.


  1. Just hit next to import after you feel everything is correct and it will automatically import the contacts for you – there might be errors, and you can view them by clicking the link provided at the last page.

Duplicate Detection

The import wizard works with the Microsoft CRM Duplicate Detection rules; by default, it will check contacts for matching email addresses. You can of course turn these rules off or add new ones within the CRM system to adjust to your preferences.


No comments:

Post a Comment