Note: Before you begin, please read Save email headers in SharePoint, which describes an automatic and simple way to configure email header mapping, without administrator configuration.
This article explains how to map email headers to SharePoint document properties, using the SharePoint Web UI.
To enable this mapping, you should configure the SharePoint document library as follows:
EMAIL HEADER | TYPE | DESCRIPTION |
---|---|---|
Attachments * | Single line of text or Yes/No | Indicates if the email message contains attachments. The default value should be No. |
Categories | Multiple lines of text | Message categories. |
Cc * | Multiple lines of text | The identity of the secondary recipients of the message. It is recommended to set this column with Allow unlimited length in document libraries set to Yes. |
Bcc | Multiple lines of text | The identity of the blind recipients of the message. This field is saved to SharePoint only if explicitly set by the administrator. It is recommended to set this column with Allow unlimited length in document libraries set to Yes. |
ConversationIndex | Single line of text | A unique identifier for the conversation. |
ConversationTopic * | Single line of text | The common subject of the email thread. This column facilitates creating a SharePoint view to show related emails. Read Grouping email messages for more information. |
Date * | Date and Time | The date and time when the message was sent. |
From * | Single line of text | The address of the message sender. |
Importance | Single line of text | The message’s importance. |
InReplyTo | Single line of text | The contents of this field identify previous correspondence that this message answers. |
MailPreviewData * | Multiple lines of text | Stores the message content compressed, for the Show Preview command. It is recommended to set this column with Allow unlimited length in document libraries set to Yes, and Add to default view unchecked (to hide the column). Read Enable email previewing to learn more. |
MessageID | Single line of text | A unique identifier for the message. |
MessageClass | Single line of text | The type of the item (message, appointment, post, etc.). Used to show the correct item icon. Read Assign icons to uploaded Outlook items to learn more. |
Received | Date and Time | The date and time when a message is received. |
References | Single line of text | The contents of this field identify other correspondence that this message answers. |
ReplyTo | Single line of text | Indicates any mailbox(es) to which responses are to be sent. |
Subject * | Single line of text | The subject of the message. |
Sensitivity | Single line of text | The message’s sensitivity. |
To * | Multiple lines of text | The identity of the primary recipients of the message. It is recommended to set this column with Allow unlimited length in document libraries set to Yes. |
Notes: All multiple line properties should be defined as plain text.
Email messages uploaded to SharePoint through harmon.ie can be grouped by the ConversationTopic column in the SharePoint web interface. This feature allows you to view email messages in a pseudo-conversation view.
During the upload process, the email Subject column is stripped from the common prefixes to the core text, and the stripped subject is saved in the ConversationTopic column.
To save the list of Bcc recipients in SharePoint, provision the ExposeBcc registry key to all users, and set its value to True.
To learn how to centrally and remotely provision registry keys, read the knowledge base article harmon.ie for Outlook - Administrator's Settings.
Issue: Non-English characters in email headers are not saved correctly to SharePoint.
Cause: Outlook is configured to save messages in ANSI format instead of Unicode format which holds support for international characters.
Resolution: Configure Outlook to save messages in Unicode format: