Chapter 38. Collaboration with Outlook and SharePoint

Overview of SharePoint 905

Setting Up Alerts 909

Working with Shared Documents 915

Working with Shared Contacts in Outlook 922

Integrating Outlook and SharePoint Calendars 924

Managing SharePoint List Connections in Outlook 926

Configuring Alerts from Outlook 927

Using Outlook to Work with SharePoint Libraries and Files 931

MICROSOFT SharePoint is a set of technologies that form a rich collaboration framework for sharing documents, calendars, and other data. SharePoint is much more than just a tool for sharing documents or data, however. Its portal features enable organizations to create a rich portal experience for users, complete with audience targeting and personalization features. The Business Data Catalog (BDC) and Business Connectivity Services (BCS) features, in SharePoint 2007 and SharePoint 2010 respectively, provide the tools needed to integrate SharePoint with back-end line-of-business solutions like SAP, Oracle, Structured Query Language (SQL), Business Objects, and many others. The Web 2.0 features of SharePoint, such as wikis and blogs, enable people to connect and share information in a wide variety of ways. These features are just some of the ones offered by SharePoint. This chapter provides an overview of these features and explains how to use the collaboration features in SharePoint from Microsoft Outlook, how to use Outlook as a tool for creating and consuming SharePoint data, and how to publish Outlook data to SharePoint.

The SharePoint name actually encompasses multiple services and components. The 3.0/2007 version of SharePoint includes Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server (MOSS) 2007. The latter builds on Windows SharePoint Services 3.0 as a foundational set of services. Windows SharePoint Services provides the framework for document sharing, portals, collaboration features, workflows, and several other core features. MOSS 2007 extends these core services with additional features and functionality. Windows SharePoint Services can stand on its own as a collaboration tool, although it doesn’t offer the same breadth of features that MOSS does. Windows SharePoint Services is an included feature of Windows Server 2003 and a separate download for Windows Server 2008. Windows SharePoint Services is licensed as part of the operating system and requires a Windows Server Client Access License (CAL) to access. MOSS 2007 is licensed separately, requiring a server license and at a minimum a SharePoint Standard CAL. If you will be leveraging the Enterprise features in MOSS, each user also needs an Enterprise CAL in addition to the Standard CAL.

As with MOSS 2007, SharePoint Server 2010 builds on a set of core SharePoint services, which in 2010 are named SharePoint Foundation 2010. Also like its predecessor, SharePoint Foundation 2010 is licensed as part of the Windows Server operating system, so each user who accesses SharePoint must have a Windows Server CAL.

SharePoint Server 2010 builds on the features and functions in SharePoint Foundation 2010 to offer a much broader breadth of services and features than the basic SharePoint Foundation features. Also like 2007, SharePoint Server 2010 requires a Standard CAL for all users and the addition of an Enterprise CAL in environments where Enterprise features are enabled.

As mentioned earlier, SharePoint relies on Windows SharePoint Services 3.0 (for the 2007 version) or SharePoint Foundation 2010 to provide its core, foundational features. These features encompass portals for delivering web content, document sharing, sharing of calendars and contacts, workflows for automating processes such as document approvals, and others. The following list describes the key feature areas that underlie SharePoint:

Collaboration environments built on Windows SharePoint Services or SharePoint Foundation can be very useful for sharing documents, calendars, and other information, and are often used by large and small companies alike to enable collaboration among groups of people. These foundational features do have some limitations, however, and that’s where MOSS and SharePoint Server 2010 come into play.

These products extend SharePoint functionality in several ways:

As stated earlier, one of the key features of SharePoint is the ability to integrate with Microsoft Office applications. These features include document sharing, which can be done from almost any Office application; lists, which can be synchronized with Microsoft Excel or Microsoft Access files; and Calendar lists, contacts, and alerts, which can be linked to Outlook. In addition, Microsoft SharePoint Designer can be used to edit and customize SharePoint pages. This chapter focuses mainly on the integration of SharePoint and Outlook 2010 to help you consume SharePoint information in Outlook, as well as publish your Outlook data to SharePoint. Before diving into SharePoint and Outlook integration, this chapter explores and explains some common SharePoint tasks and how to accomplish them, starting with setting up alerts.

Alerts are used when you want to be notified when content on a SharePoint site changes, such as when a document is modified or a new item added to or modified in a list. Alerts are sent through email. For example, if a document changes for which you have configured an alert, you receive an email when someone else has modified the document.

To set up an alert in a WSS 3.0 or MOSS site, follow these steps:

After you have created an alert, you will be notified each time the alert criteria set on the New Alert page are met. You can view a list of all the alerts you have configured on the site by clicking View My Existing Alerts On This Site on the New Alert page. The My Alerts On This Site page, shown in Figure 38-3, shows all the alerts you have configured on the site. You can delete alerts by selecting the check boxes next to the alerts that you want to delete and then clicking Delete Selected Alerts. It is also possible to add an alert for a list or document library (although not individual items) on the My Alerts On This Site page. To do this, click Add Alert, select the library or list for the alert, and then click Next. Set the options on the New Alert page as described earlier in this section.

You use a somewhat different approach to adding alerts in SharePoint Foundation 2010 and SharePoint Server 2010 sites. This method also is available in WSS 3.0 and MOSS sites for adding alerts to entire lists or libraries, although the interface is somewhat different.

Document sharing is simple with SharePoint, and it can be done in one of two ways. If you have an existing Office system document, it is an easy process to add the document to a SharePoint document library. If you don’t already have a document created, you can create the document directly on the SharePoint site. When you create a document in a SharePoint site, the appropriate application opens automatically and the template associated with the document type in SharePoint is used. You can then save the document to your local computer or to the SharePoint site.

In addition to creating and adding documents to the SharePoint site, you can do a number of things with existing documents in SharePoint: You can edit or remove existing documents, and you can use features such as document version history, checkout, and check-in to control versions.

Document options for each item in a document library are found in the item’s drop-down menu. Position the mouse pointer over a document name and a drop-down arrow appears. When you click the arrow, the Item drop-down menu (shown earlier in Figure 38-1) appears. From this menu, you can edit the document (clicking the document name also has this effect); view or edit the document properties, which include the name and a descriptive title for the document; delete the document from the library; manage permissions; start workflows; and check in or check out the document.

The key features in a shared document library are the version control features. In SharePoint, these features include the ability to check a document in and out as well as view its version history. When you check out a document, other users can no longer edit the document until you return it to the document library by checking it in.

To check out a document, simply choose Check Out from the Item drop-down menu, as shown in Figure 38-11. Click OK when warned that you are about to check out the document. The icon in the Type column changes to display a green arrow to indicate that the document is checked out. After you specify that you want to check out the document, click the Item drop-down arrow again and click Edit In Microsoft Word (or whichever application name appears). The document is downloaded to your computer and displayed in the application for editing.

When you have finished editing, you can save the document with or without checking it in. To save without checking it in, click File, Save. If you then close the document without checking it in, whichever Office application you are using prompts to ask if you want to check in the document. You can click Yes to check it in, or you can choose No and then return to the SharePoint site and check in the document.

Checking a document back into the document library from SharePoint is handled from the same drop-down menu as checking out. Click the Item drop-down arrow, and then click Check In. The Check In page shown in Figure 38-12 is displayed. Enter any comments for the version history, and then click OK. A message box appears, asking whether you want to continue. Click Yes. The document is then checked in.

In the document library, choose Version History from the Item drop-down menu for a document. If version history is enabled for the document library, every time a document is checked in, it will appear in the version history, as shown in Figure 38-13. You can view each version of the document by pausing the mouse pointer over the date and time for a version and then clicking View. You also can restore a document by clicking the Restore option on this drop-down menu. You can delete old versions by clicking Delete Minor Versions, or click the Delete All Versions link to delete all document versions.

SharePoint provides lists that can be used to store, manage, and share a variety of information. One of the defined list types is contacts, which is used to store contact information in a way similar to the Contacts folder in Outlook. You can view these shared contacts within SharePoint or connect them to Outlook. This section explains how to use these shared contacts in Outlook.

Start by navigating in SharePoint to the contacts list you want to use in Outlook. Click the List tab in the List Tools group on the ribbon, then click Connect & Export and choose Connect To Outlook (see Figure 38-14). If you are working with a WSS 3.0 or MOSS site, click Actions, Connect To Outlook. (You don’t need to click Connect & Export if your screen size is large enough that the Connect To Outlook item appears in the Connect & Export group.)

A dialog box opens, similar to the one shown in Figure 38-15, prompting you to allow the connection. The dialog box indicates the Uniform Resource Locator (URL) of the site and other information. Click Allow. Outlook then displays a dialog box that prompts you to confirm that you want to add the list to SharePoint. You can simply click Yes to add the list to Outlook without configuring any other settings. Alternatively, click Advanced to display the SharePoint List Options dialog box shown in Figure 38-16.

In the SharePoint List Options dialog box, use these two options to control the connection:

When you are satisfied with the settings, click OK, and then click Yes. The SharePoint list appears in the Navigation pane when your Contacts folder is open, and the contents of the SharePoint list appear in Outlook, as shown in Figure 38-17.

With the list now connected to SharePoint, you can work with it just as you would a local Contacts folder. You can view individual items and even update items, subject to your permissions in SharePoint. Changes that you make in Outlook to the list are synchronized back to the SharePoint list the next time a send/receive action occurs for the list.

You can connect a SharePoint Calendar list to Outlook 2010, just as you can a Contacts list. SharePoint calendars are typically used to share schedules such as project timelines, vacation schedules, and so on. When you create a team site in SharePoint, the site includes a Calendar by default. When you connect the SharePoint calendar to Outlook, the calendar looks and functions just like the calendars in your local Outlook data store(s). Subject to your permissions in the SharePoint calendar, you can modify the SharePoint calendar in Outlook and the changes are synchronized to SharePoint the next time a send/receive action takes place for the list.

To link a Calendar list to Outlook 2010, follow these steps:

When the calendar is linked to Outlook 2010, it is displayed as shown in Figure 38-18. You can see the new calendar listed in the Navigation pane on the left.

If you have Contribute permissions in the SharePoint calendar, you can modify the SharePoint calendar from within Outlook. Just click in or select a time slot and add appointments as you would for a local calendar. The next time a send/receive action occurs for the list, those changes are synchronized to the SharePoint list, where they will be visible by other SharePoint users.

Because SharePoint calendars that are linked to Outlook function like Outlook calendars, you can use the same features for both. For example, you can overlay a SharePoint calendar on one or more of your local calendars for a combined view. Just select the calendars in the Navigation pane to display them, and click the View In Overlay Mode button at the top of the calendar to overlay it with the others.

To manage settings for SharePoint lists in Outlook, click File, Account Settings, and finally Account Settings. In the Account Settings dialog box, click the SharePoint Lists tab, as shown in Figure 38-19.

To change the settings for a SharePoint list’s connection to Outlook, click the list and then click Change. The SharePoint List Options dialog box, similar to the one shown earlier in Figure 38-16, is shown. You can use this dialog box to change update limits and specify whether the list appears on all computers where you run Outlook. To remove a connected SharePoint list from Outlook, click the list on the SharePoint Lists tab and then click Remove. Removing a list from SharePoint only breaks the connection to SharePoint; it does not delete the SharePoint list itself from SharePoint.

We looked at alerts in the section Setting Up Alerts, on page 909. If you received alerts from multiple sources, you might prefer to manage those alerts from Outlook. Although Outlook doesn’t technically provide the features or capabilities to manage your alerts from the Outlook interface, it does enable you to navigate to your alerts from the various sources currently sending you alerts.

To manage SharePoint alerts from Outlook 2010, follow these steps:

If you have a lot of alerts configured in a SharePoint site (or multiple sites), they can fill your mailbox quickly and distract from other messages. Outlook 2010 provides a simple way to create rules based on alerts. As you learned in Chapter 11, rules are used to process messages when they arrive in your mailbox. To configure a rule based on an alert, follow these steps:

When the rule is created, Outlook displays the Success dialog box, shown in Figure 38-25. You are notified that the rule is a client-side rule and given the option to run the rule against your mailbox immediately to find any messages that fit the rule criteria.

After you click OK in the Success dialog box, you can see the newly created rule by clicking the E-Mail Rules tab in the Rules And Alerts dialog box, which is already open.

As already explained in previous sections of this chapter, you can connect SharePoint lists and document libraries to Outlook 2010. This makes the library and its items available within Outlook 2010 so that you don’t have to use a web browser to view and work with them—you can use Outlook 2010 instead. For example, you might want to have a list of current project documents that have been uploaded to your team’s SharePoint site as you create email messages to update your team members, support staff, and management. By having the list of documents appear in Outlook, you can view the document name, its status, and other information quickly without leaving Outlook. Also, if you open a SharePoint document from within Outlook, that file is stored locally on your hard drive while you view it. This makes the document open faster and reduces network traffic. If you make any edits to the document, you then check in the file to the SharePoint site. Files are stored on your hard drive in your personal folders (.pst) file.

Not only can you open and view SharePoint files in Outlook 2010, you also can edit them. Before doing so, however, you should return to the SharePoint site and check out the document so that no one else can work on the document while you are working on it. (Outlook 2010 does not provide a way to check out the document locally.)

To edit the file, double-click it. The file opens in the default application for that file format (for example, an .xlsx file opens in Excel 2010, .pptx in PowerPoint 2010, and so on). For applications compatible with SharePoint, a banner appears across the top of the document telling you that the document is an offline server document and that you should save the file to the server later, as shown in Figure 38-30.

Click Edit Offline. A message box appears, telling you that the document will be stored on your computer in the SharePoint Drafts folder. Click OK, and then edit the file. After you complete your edits, click File, Save to save the file, and then close the application. If you are connected to your SharePoint site at this time, the Edit Offline dialog box appears. You can click Update to update the SharePoint site with your edited file. (You also can click Do Not Update Server to update the server later.)

When you click Update, the application (such as Word 2010) saves the changes to the SharePoint site.

If you chose not to update the files using the Update button, return to Outlook 2010 and then click Send/Receive when you are ready to update your files. Outlook 2010 synchronizes with the SharePoint Site to save your changes in the online library.

If the SharePoint document library is configured to accept documents by email, you can add a document to a library simply by sending an email message, with the document attached, to the library. This is handy if you do not want to go through the process of opening your web browser, connecting to your SharePoint site, locating a library, and uploading the file to it.

To use this feature, you need to know the email address for the library to which you plan to send the file. Some organizations include the email address for libraries in their address book. If you have access to the list’s settings, look in the List Information area for an E-Mail Address item. If your library is configured to receive files via email, the address will appear here.

Others might include the email address as part of the library’s description—for example, placing the address beneath the title of the library so that users can see it while viewing the library in a web browser. After you get the address, if your company does not already include the address in your Contacts folder or in the Outlook Address Book, add it to your Contacts folder.

After you get the email address, return to Outlook 2010 and then create your message. Attach the file that you want to send to the SharePoint site. Add the address of the library in the To box, and then click Send.