Mapping E-Mail Headers to SharePoint Metadata
When uploading e-mail messages from Lotus Notes to SharePoint, the e-mail headers (From, To, CC, Subject, Date, etc.) can be automatically mapped to SharePoint columns. To enable this mapping, the SharePoint document library needs to be set up with e-mail specific columns. The recommended way to add e-mail columns to SharePoint document libraries is described in the Mainsoft knowledge base article Displaying E-Mail Headers on SharePoint.
Notes:
- If the SharePoint document library is configured to receive incoming e-mails, it includes the To, From, and Subject columns. The compatible e-mail headers are automatically mapped to these columns when uploading e-mail messages with Mainsoft SharePoint Integrator. This approach gives an alternative, but partial, solution of mapping e-mail headers to SharePoint columns.
- When uploading an e-mail message with attachments to a SharePoint 2010 library with column validation, and simultaneously replacing attachments with links, the e-mail headers are not persisted as SharePoint document properties.
The e-mail header information is mapped to SharePoint columns according to the table below:
| E-mail header | SharePoint column | Description | SharePoint column type |
|---|---|---|---|
|
Received |
EmailReceived;Received |
A copy of this field is added by each transport service that relays the message. |
Single line of text |
|
Attachments |
Attachments;HasAttachments;WithAttachments |
Indicates if the e-mail message contains one or more attachments. |
Yes/No |
|
To |
EmailTo;To |
The identity of the primary recipients of the message. |
Single line of text |
|
From |
EmailFrom;EMailSender;From;Sender |
The identity of the person who sent the message. |
Single line of text |
|
Subject |
EmailSubject;Subject |
A summary of the message. |
Single line of text |
|
Cc |
EmailCc;Cc |
The identity of the secondary recipients of the message. |
Single line of text |
|
Date |
EmailDate;Date |
The date and time when the message was sent. |
Date and Time |
|
In-Reply-To |
EmailInReplyTo;In-Reply-To;InReplyTo |
The contents of this field identify previous correspondence that this message answers. |
Single line of text |
|
References |
References;EmailReferences |
The contents of this field identify other correspondence that this message answers. |
Single line of text |
|
Reply-To |
EmailReplyTo;Reply-To;ReplyTo |
Indicates any mailbox(es) to which responses are to be sent. |
Single line of text |
The mapping between e-mail headers and SharePoint fields is configurable from the mapping table in Mainsoft SharePoint Integrator’s preferences. From the application menu, select File > Preferences... > SharePoint > E-mail Settings and click the Mapping... button to open the E-mail Header Mapping dialog.
From here, you can edit and remove the mapping of existing e-mail headers as well as add new mappings. Multiple SharePoint fields, separated by a semicolon, can be configured as candidates to be mapped to an e-mail header. Mainsoft SharePoint Integrator assigns each header value in an e-mail message to only one SharePoint field - the first in the list of fields that exists in the document library. Any e-mail header field can be mapped to SharePoint metadata.
