Integrate External SharePoint 2010 List to Outlook 2010-Tutorial

No.of Views2897
Bookmarked0 times
By  Mostafa Elzoghbi   On  10 Nov 2010 10:11:24
Tag : SharePoint , Collaboration
In this tutorial, i will show to how to Integrate External SharePoint 2010 List to Outlook 2010
emailbookmarkadd commentsprint

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at



In this tutorial, i will show how to integrate SharePoint 2010 external list that is configured to pull information from an external system into outlook 2010.

So, To begin the office 2010 has unique and enhanced integration with sharepoint 2010, If you are able to configure SharePoint 2010 to pull data from external data using BCS External List. You will be able to manage this list in outlook 2010.

First, When you create external list that is designed to be used in outlook the ECT ( External Content Type ) has to be with type Office item type and select from the options: Task, Post, Appointment or contact.

How to connect to external list using SPD:

1) Open SPD with the SP site.
2) Select External content type and click on External content type from the ribbon.
3) Type the ECT name and select the office item type from the list.
4) select the data source and do the mapping.
5) Note: You have to map the fields to the appropriate office mapping.
6) Save your ECT and click on Create Lists and Form from the ribbon.
7) Now you have the ECT and the list in the SharePoint Site.
8) Before test the list, set the permission to the External list from the central admin -> application management -> application services -> select BCS -> select your list and click on set permissions - > provide the required permissions per user.
9) Visit your SP site and click on lists link and select your list to check it.

Note: I went through how to create ECT and External List in SP 2010. There is more tips and security best practices for above items - Please check MSDN how to setup BCS with SSS service.

How to get the created external list on your outlook ?

1) Select your list.
2) Select List tab and click on connect to outlook.
3) an Add-In will be installed and configured to your outlook 2010 to the list.

Now, You will be able to manage the list once the configuration is done and outlook will be launched automatically once SP 2010 is done with the configuration.

Image Loading

How can i change the mapping for the created ECT ? 

The only thing you need to do is to open SPD and select your ECT - > Read Item and then click on Edit Operation from the ribbon and change the ECT field mapping and save it.

Tip: if you have your outlook 2010 is opened, and you right click on the contact list and run the sync option you won't be able to get the new mapping fields. Close the outlook and open it again.

Image Loading


In this tutorial, you have learned how to Integrate External SharePoint 2010 List to Outlook 2010. i hope helps.

Sign Up to vote for this article
About Author
Mostafa Elzoghbi
Member Type-Junior
Location-United States
Joined date-07 Jun 2010
Home Page-
Blog Page-
Other popularSectionarticles
By:asssssssssssssssssssssssssssssDate Of Posted:1/28/2014 5:04:10 AM
Leave a Reply
Display Name:
(not display in page for the security purphase)
Please refresh your screen using Ctrl+F5
If you can't read this number refresh your screen
Please input the anti-spam code that you can read in the image.
^ Scroll to Top