Home > Free tools facilitate large-scale Outlook and SharePoint integrations
Tutorial:
EMAIL THIS

Free tools facilitate large-scale Outlook and SharePoint integrations

09 Oct 2009 | SearchExchange.com

Exchange Server tips, tutorials and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Microsoft doesn't offer an automated tool to link SharePoint and Outlook on a large scale. Two free tools -- the MFCMAPI utility and 2007 Office System Administrative Templates -- can help. Here's how they work.
Manually setting up Outlook on a single machine is the first step toward large-scale deployment. But first you must check to see if your computer is running a 32-bit or a 64-bit version of Windows. Then, download the appropriate version of Microsoft's MFCMAPI tool from the CodePlex website.

This utility runs against Outlook, not Exchange, so be sure that you don't automatically download the 64-bit version. You'll only need to download the executable file. Symbol files are available, but you won't need them since you're not doing any debugging.

Next, open Outlook and verify that the SharePoint calendar is accessible. Open the MFCMAPI tool and click OK to clear the introductory screen. Choose the Logon and Display Store Table option from the tool's Session menu.

If you have multiple Outlook profiles configured, you'll be prompted to select which Outlook profile you'd like to use -- even though Outlook should already be open. Choose the profile you want to use and click OK. When you do, the MFCMAPI screen should look something like that in Figure 1.

Screenshot of Microsoft's free MFCMAPI utility
Figure 1. Screenshot of Microsoft's free MFCMAPI utility.

Notice that the Display Name of the last item on the list is SharePoint Lists. Double-click the SharePoint Lists option to open a separate window containing a tree structure on the left side.

Navigate through the console tree to: Root Container -> Top of Personal Folders. Expand this container and you should see the SharePoint calendar that you linked to Outlook (Figure 2 ).

Select the listing for your SharePoint calendar.
Figure 2. Select the listing for your SharePoint calendar.

Right-click on the listing for your SharePoint calendar and select Open Associated Contents Table. You'll now be taken to a screen similar to Figure 3.

I've selected the listing for SharePoint in the top window pane, causing the lower pane to display all of the data from the top pane. Then, I selected a property with a name that begins with stsync://. Outlook uses this URL to connect to and synchronize with the SharePoint calendar. Make note of this URL .

Make note of the URL that begins with stsync://
Figure 3. Outlook uses the stsync:// URL to connect to and sync with the SharePoint calendar.

The next step is to download and install the second tool, the 2007 Office System Administrative Templates. To complete the process, you need to modify the Group Policy.

To do so, navigate through the Group Policy Object Editor to User Configuration -> Administrative Templates -> Microsoft Office Outlook 2007 -> Tools -> Account Settings -> SharePoint. As you can see in Figure 4, there are several SharePoint-related settings. You must enable the Default SharePoint Lists setting and assign it the stsync:// URL. Finally, enable the Do Not Roam User's SharePoint Lists setting. Everyone in the Group Policy should receive the SharePoint calendar.

Enable the Default SharePoint Lists setting and assign the stsync:// URL
Figure 4. Enable the Default SharePoint Lists setting and assign the stsync:// URL.

About the author: Brien M. Posey, MCSE, is a five-time recipient of Microsoft's Most Valuable Professional (MVP) award for his work with Exchange Server, Windows Server, Internet Information Services (IIS), and File Systems and Storage. Brien has served as CIO for a nationwide chain of hospitals and was once responsible for the Department of Information Management at Fort Knox. As a freelance technical writer, Brien has written for Microsoft, TechTarget, CNET, ZDNet, MSD2D, Relevant Technologies and other technology companies. You can visit Brien's personal website at www.brienposey.com.

Do you have comments on this tip? Let us know.

Do you know a helpful Exchange Server, Microsoft Outlook or SharePoint tip, timesaver or workaround? Email the editors to talk about writing for SearchExchange.com.

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Microsoft Outlook
What's new in Microsoft Outlook 2010?
Top 5 Exchange mobile tips of 2009
How to create multiple instances of OWA
Exporting Exchange Server mailbox messages into .pst files
Microsoft Outlook mailbox is not shrinking as expected
Creating an active GAL on Outlook 2003 and 2007
Top 5 Microsoft Outlook tips of 2009
How mailbox rules and Windows Desktop Search affect Outlook 2007
Error message appearing after user has been deleted in Outlook 2003
Creating an Outlook 2007 user profile in Windows Vista
Microsoft Outlook Research

Microsoft Office SharePoint Server
How to display Exchange Server 2007 public folders via SharePoint
Industry expert analyzes future of messaging
Tackling the social messaging dilemma
Microsoft Outlook and SharePoint interoperability considerations
Displaying Exchange 2007 public folders in SharePoint
Microsoft Outlook and SharePoint calendar dos and don'ts
Fix Outlook 2007 and SharePoint synchronization breaks
A behind-the-scenes look at Outlook 2007 and SharePoint integration
Organize meetings with Outlook 2007 and Meeting Workspaces
Synchronize SharePoint resources with Microsoft Outlook 2007

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
bacn  (SearchExchange.com)
email bankruptcy  (SearchExchange.com)
offline folder file  (SearchExchange.com)
OST file  (SearchExchange.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary




E-mail Administration Tips - Active Directory, Mail Protocols, MOM
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2004 - 2010, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts