SharePoint Integration with Outlook 2007, Part 1 - 27 Apr 2007

Microsoft Windows SharePoint Services is a useful tool that lets you collaborate with your colleagues and share documents. The main drawback has been that you needed to be online to access and modify information. For me, it's also hard to keep track of the multiple sites I work with. However, Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 now combine with Microsoft Office Outlook 2007 to provide a sophisticated way to work offline with SharePoint data. By using Outlook to store SharePoint data, you have a single place to look up and modify schedules, contact information, documents, and tasks; new items are available in one place without accessing different SharePoint sites.

With Outlook 2003, you can access some lists offline, such as Calendar or Contacts, but this access is read-only; you must make any modifications on the SharePoint server. Document libraries aren't available offline with Outlook 2003. Outlook 2007 lets you synchronize calendars, contacts, tasks, and discussion boards into a personal folder file (PST). You can add to, edit, or delete items when you're offline, and when you're back online, changes will synchronize with the SharePoint server. Also, you can synchronize document libraries: Even though items are stored as read-only in your PST, Microsoft Office 2007 system applications, such as Word 2007, PowerPoint 2007 and Excel 2007, let you edit documents and store your modifications in the SharePoint Drafts folder. When you're online and open the documents, you'll be prompted to synchronize the changes back to the server. You can't synchronize some SharePoint items, such as announcements, links, custom lists, database applications, issue tracking lists, and surveys.

You enable synchronization with Outlook 2007 by accessing the SharePoint list or document library you want to synchronize and clicking "Connect to Outlook" on the Actions menu. This menu item is available only if you're using Outlook 2007 and Windows SharePoint Services 3.0 or SharePoint Server 2007. You can choose which lists to sync only from SharePoint, not from Outlook. When you enable the sync for the first time, a new PST file called "SharePoint Lists" is created. This file can't be shared among multiple Outlook profiles, and if you remove it, you'll break the connection to SharePoint. Outlook stores all items downloaded from the SharePoint site in the PST.

Outlook's Send/Receive function downloads the item's header information first, then the body, just like Cached Exchange Mode. For immediate download, click the “Download this document" button. You can also see which documents are locally available by accessing the Offline Documents folder in Search Folders.

The synchronization process is integrated into Outlook's Send/Receive Settings; you can define specific synchronization settings by choosing Define Send/Receive Groups. By default, all your SharePoint sites will be synchronized at the same time as your email. However, you can create a Send/Receive Group for SharePoint and configure when synchronization takes place. For more granular control, you can configure additional groups for individual SharePoint lists and set the time when they should be updated.

You remove SharePoint lists from synchronization either by deleting the folder in Outlook or by using the Remove button from the SharePoint Lists tab in the Account Settings dialog box. This removes all items from the folder and the local PST but doesn't alter the online contents of the SharePoint lists. Closing the PST or removing it from the Data Files tab in the Account Settings dialog box will also break the link to SharePoint; to reconnect, you need to add lists for synchronization from SharePoint again, which creates a new PST and makes the old one obsolete. If you break the link, remember to manually delete the old PST from your folder structure.

In the next column, I'll look deeper at how SharePoint synchronizes calendars, tasks, contacts, and documents with Outlook 2007, and I'll explore some of the limitations that come with this method.

Outlook Internet Site of the Month
From now on, I plan to end each of my columns with a note about something interesting for Outlook that I've found on the Web. This month's focus is Ryan Gregg's PDF Preview Handler for Outlook/Vista. This tool lets you view PDF files in Outlook 2007. It uses Adobe Acrobat Reader 7.x or later and works with Windows Vista and Windows XP. You can also view PDFs through Windows Explorer in Vista. Use the following link to get this freeware tool: http://blogs.msdn.com/rgregg/archive/2007/03/17/pdf-preview-handler-for-outlook-vista.aspx

Corrections to this Article:

Discuss this Article 13

ENG HAI (not verified)
on Oct 13, 2007
very good
Janet (not verified)
on Oct 30, 2008
I found your articles quite interesting... All nicely bookmarked now for future reference. I am still struggling with one thing when synchronizing a SharePoint document with Outlook. I prefer not to put all of the documents on the SharePoint site into different folders (since I have to go to each folder and open it to see what is inside). So I group the documents using custom views. Outlook uses custom views and grouping as well, so no problem, right? Yes and no. Outlook apparently doesn't synchronize all the information associated with a document, so that chances are good that you are not going to be able to group them using the same information that is associated with the document on SharePoint. For example, if I use a site that associates documents with the meeting they are being discussed at, and view those documents grouped by meeting in the document list, then I am unable to group them in Outlook, I just have one long list of all documents. Unless... you know some way to also synchronize things like the data in all the columns associated with the document?
Jayen (not verified)
on Jun 9, 2008
I was looking for integration of Share Point documents with Outlook 2003 only, this site has given me information which have saved a lot of time and clears all confusion that why "Connect to Outlook" is not appearing in Share Point site. Thank you Windows IT Pro & Siegfried Jagott for sharing amongst all.
AnneG_editor
on Apr 28, 2008
zbatia, thanks for pointing out the incorrect link. I've updated the URL for Ryan Gregg's PDF Preview Handler for Outlook/Vista blog post, which includes links to a couple PDF preview handlers. Hope this helps!
zbatia
on Apr 28, 2008
broken link!!! page code error
Siegfried (not verified)
on Sep 1, 2008
Hi Ericgilroy, As a user, you can view your current Sharepoint version by clicking on Site Actions / Site Settings. On the Site Information pane, you can see the Version number. If it lists 12.0.0.x you have Sharepoint 2007, if it lists something below, you probably have Sharepoint Portal Server. Sharepoint 2007 is version 3.0, thus there were 2 versions before it. I hope I answered all your questions. Feel free to ask more! Best, Siegfried Jagott
ericgilroy (not verified)
on Jun 20, 2008
Does anyone know how I can tell if my company is running SharePoint 2007? I am considering buying Outlook 2007 (upgrading from 2003). Also, how many versions of SharePoint have been released?
eneas (not verified)
on May 19, 2008
what about remote access
Rajesh (not verified)
on Mar 12, 2008
This article is very good
Peter (not verified)
on Apr 30, 2007
Great article.
Siegfried (not verified)
on Nov 5, 2008
@Pknapp, I have verified your statement regarding the version numbers again: Sharepoint 2003 with Service Pack 3 is 11.0.8168.0 Sharepoint 2007 is version 12.0.0.6327. Best, Sigi
Peter (not verified)
on Sep 2, 2008
@SigiJ I am sorry your definition of versions is rubbish. We have 12.0.0.4518 which is SP 2003 for certain. Regards, Pete www.ccsleeds.co.uk
shirley (not verified)
on Oct 21, 2008
There is a 3rd party tool called myDocs which is an add-in for Outlook, that lets us view SharePoint Document Libraries by clicking standard Outlook folders, and drag emails into these folders to upload into SharePoint.You can visit http://www.nsynergy.com/Products/myDocs/Pages/Demonstration.aspx for more information.

Please or Register to post comments.

IT/Dev Connections Exchange Server

Las Vegas
September 30th - October 4th

Paul ThurottYou'll have the opportunity to experience:
• Future Deopyments
and Integrations
• Hybrid Deployments
• Exchange Online
• Windows 8 Deployment
and much more!

Come See Tony Redmond & Mark Minasi in Person!

Early Registration Now Open

Current Issue

May 2013 - The NameTranslate object is useful when you need to translate Active Directory object names between different formats, but it's awkward to use from PowerShell. Here's a PowerShell script that eliminates the awkwardness.

CURRENT ISSUE / ARCHIVE / SUBSCRIBE

Windows Forums

Get answers to questions, share tips, and engage with the Windows Community in our Forums.