Subscribe to Windows IT Pro

 

Get Newsletters

  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Productivity Tips

Subscribe Now!

April 27, 2007 12:00 AM

SharePoint Integration with Outlook 2007, Part 1

Windows IT Pro
InstantDoc ID #95919
Rating: (15)

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:

Related Content:

ARTICLE TOOLS

Comments
  • Siegfried
    4 years ago
    Nov 05, 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

  • Janet
    4 years ago
    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?

  • shirley
    4 years ago
    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.

  • Peter
    4 years ago
    Sep 02, 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

  • Siegfried
    4 years ago
    Sep 01, 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

You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

White Papers

Get your Windows 7 deployment off to the right start by implementing PC lockdown. A locked-down environment is easier and cheaper to support since users are less likely to make unnecessary changes to the core system configuration - read more here!

Essential Guides

Is your iSCSI "lossy"? The reality is that most off-the-shelf Ethernet hardware deployed for iSCSI can lose packets, resulting in slow performance or application downtime. Learn how to assess your current iSCSI infrastructure and engineer an advanced iSCSI SAN infrastructure.

Web Seminars

What's the best way to keep your network safe from malware? In this web seminar, security expert Greg Shields suggests an alternative method to the traditional blacklisting approach that is common with anti-virus and anti-malware solutions.

eLearning Series

We bring the experts direct to you to share their real-world perspective and expertise. During each event, three sessions stream in real time, so you can learn, ask questions, and get solutions.
Upcoming event: Getting the Most with Exchange 2010 with Paul Robichaux

Subscribe to Windows IT Pro!

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.