Organic integration of Outlook and SharePoint

Productivity boost for Information Workers can be achieved when users are not required to leave their Outlook environment to interact with SharePoint. The most common use case for this scenario will allow saving and copying Emails from Outlook to SharePoint, so Emails can be managed as records and ILM policies can be applied.

We will review the different ways by which emails can be transferred from Outlook to SharePoint.

Enable and Configure Email Settings for Document Library

Email can be added to SharePoint libraries or lists by sending an email to an email address assigned to that list. Users can include the email address along with other recipients and email will be stored automatically in designated Library

Process

1. Open the document library in which you want to receive and store emails
2. Select the Library from the ribbon menu.
3. Select “List or Library Settings”
4. Under Communications section of the Settings page, Select “Incoming e-mail settings”
5. In the Incoming Email Settings page, activate the feature, and input a unique email address for that list.
6. If the Incoming e-mail settings link isnot visible then the list or document library type doesnot support this feature. Only the following list types has support for Incoming Email

1. E-Mail Attachments section allows to group the email attachments in the library and also provides option to overwrite files with same name
2. View the other settings on how to handle original email message and whether to archive e-mail messages only site user or any anonymous users

Advantages

1. Simple setup and can be configured by power users
2. Emails can be saved to both Lists and Document Libraries

Limitations

1. Each library or list must be activated separately because each list needs a unique email address
2. Email attributes like From, To and other meta data cannot be extracted and saved as separate columns
3. Emails and Attachments are not stored together but as separate items, which might be an issue with Compliance.

One Drive for Business

Sync tool from OneDrive for Business allows Document Library contents to be synced to your computer. The Document Library files can be accessed through File Explorer instead of web browser SharePoint interface. Once setup is completed, One Drive for Business provides two way sync between SharePoint and your File system. All changes to File System will be synced to SharePoint through OneDrive for Business.

Process

1. Browse to the Document Library which needs to be synced to local File system.
2. Click the Sync button. At the prompt, click Sync Now to start the sync app. This will start the sync process and the make the document library contents available in local machine.
3. The app automatically fills out the name and web address of your OneDrive for Business library.
4. If you don’t see a Sync button, select the Library tab and then select Sync in the Connect & Export group

1. Synced Library Folder will be listed under Favorites section of File Explorer. SharePoint folder will contain all the Synced Document Libraries.
2. Multiple Emails from Outlook can be dragged and dropped into the One Drive Folder. One Drive Sync client will upload the contents to SharePoint automatically

Advantages

1. Emails can be transferred to SharePoint in bulk, as the upload happens in the background without user intervention.
2. Email and Attachments are saved together in MSG file format. Outlook client can be used to view the emails stored in SharePoint

Limitations

1. Only 20,000 files in a Document Library can be synced up using One Drive
2. Email metadata cannot be extracted and saved in SharePoint columns

Site Mail boxes

Site mailboxes allow SharePoint document library contents and Exchange email to be accessed from Outlook. Please refer to Site Mailboxes White Paper published on how Site Mailbox becomes a central email and document sharing location that is accessed from a SharePoint site. Team can store the email conversations and documents relevant a project in a single repository.

Process

1. Browse to the SharePoint site to add the Site Mailbox.
2. On the Quick Launch, click Site Contents. On the Site Contents page, click Add an App.
3. Select ‘Site Mailbox’ to add to the SharePoint site. Please wait for 30 minutes for the operation to be completed and the mail box will be created in Exchange server
4. Site Mailbox can be accessed from Quick Launch navigation
5. In Outlook all the Site Mailboxes are listed in the lower left hand side of the Outlook menu
6. Under each Site Mailbox a subfolder called “Documents” exists. Now emails and documents pertaining to a project can be collaborated from same client interface – Browser or Outlook
7. Users can drag documents or emails to the ‘Documents’ and they are automatically uploaded to the corresponding document library “Documents” in the SharePoint site to which the Site Mailbox is related.

Advantages

1. Management and compliance made easy as Site mailboxes can be part of eDiscovery search scopes and, as a result, their mail and documents can be put on legal hold
2. Users can drag and drop emails and attachments from Outlook and upload directly to SharePoint.
3. Document and Emails stored in Site Mailbox can be viewed from Outlook interface
4. Drag and drop multiple documents from site mailbox into new email and document link is sent to the users instead of the need to send the document as an attachment

Limitations

1. Only 10 site mailboxes can be used at one time in Outlook.
2. Email metadata cannot be extracted and saved in SharePoint columns. Contents of SharePoint and Outlook cannot be searched based on Metadata.
3. Configuration of Site Mailboxes is time consuming as it involves SharePoint, Exchange and managing security certificates for implementing trust between SharePoint and Exchange machines.

Open with Explorer

Contents of the SharePoint library can be displayed in the Windows Explorer using ‘Open with Explorer’ command.

Process

1. Browse to the document library to which the emails must be copied from Outlook
2. In the ribbon, under the Library Tools section, click the Library tab. In the Connect and Export group, click Open with Explorer.
3. Windows Explorer now displays the Document library contents
4. Select single or multiple emails in Outlook. Drag the selected emails to the Windows Explorer

Advantages

1. Emails and Documents can be transferred between document libraries using drag and drop. It provides a rudimentary way to migrate contents between SharePoint destinations.
2. End users can use this feature to copy Outlook emails without complicated setup process

Limitations

1. Only document library can be opened with explorer and this feature is not available for Lists
2. During upload mandatory Metadata cannot be applied and emails will remain in Checkout status till user updates the properties through SharePoint interface
3. Email Metadata cannot be extracted and saved in SharePoint columns and hence the uploaded emails can’t be searched based on Email Metadata.

Manually Copy Emails to SharePoint

Contents can be added to SharePoint document library by drag and drop of one or more documents from file system. Drag the emails from Outlook to file system and then move to SharePoint document library.

Process

1. Select one or more emails in Outlook which needs to be copied to SharePoint document library
2. Drag the emails to File system like say Desktop.
3. The emails are now saved as MSG files in the Desktop
4. Browse to the Document library to which these emails must be added.
5. Select all the emails in the desktop, drag and drop in the SharePoint Document Library. Emails will be copied to the Document Library.

Advantages

1. Emails and messages are saved together as MSG file, so the integrity of the email is maintained.
2. Simple and straightforward process and users can see the upload progress of the emails being copied to SharePoint library

Limitations

1. For larger number of emails the process becomes cumbersome.
2. Metadata cannot be applied during the upload process. Email attributes also cannot be extracted as saved as SharePoint columns.

Third party SharePoint Outlook Integration

Outlook can be extended as SharePoint Explorer and also allow automatic capture of Email Metadata during copy of Emails to SharePoint, using PageLight. PageLight allows users to access SharePoint DMS functionalities like Check in, Check Out and Version history from Outlook. PageLight provides integration between SharePoint and Outlook and check out the various business solutions it supports like SharePoint Legal Document Management System

More to read: SEO campaign for small-scale business owners