Logo

How can I automatically map email message properties?

This article applies to:
7.x Briefcase for Window, Email Manager for Outlook
6.x Briefcase for Windows, Contributor Pro, Email Manager for Outlook

Column names for email metadata mapping are defined in an email configuration file. By default, the required SharePoint column display name matches the Outlook message field name. The email configuration file allows the default mapping from the Outlook message field name to the SharePoint column display name to be overridden.

When a .msg file is added to a document library, the product checks the file and looks for any supported message fields. If a supported field is found, there is a further check to see if there is a metadata column in the SharePoint document library with the matching display name and the appropriate data type. If a match is found, then the column is pre-populated with the value from the .msg file.

The table below lists the supported Outlook message fields with the default values for the corresponding SharePoint column names.

Email Metadata Default Column Name Type
Attachment Attachment Yes/No
Bcc Bcc Text
Bcc-Address Bcc-Address Text
Bcc-Type Bcc-Type Text
Categories Categories Text
Cc Cc Text
Cc-Address Cc-Address Text
Cc-Type Cc-Type Text
Conversation Conversation Text
From From Text
From-Address From-Address Text
From-Type From-Type Text
Importance Importance Number
Received Received Date/Time
Received-UTC Received-UTC Date/Time
Sensitivity Sensitivity Number
Sent Sent Date/Time
Sent-UTC Sent-UTC Date/Time
Subject Subject Text
To To Text
To-Address To-Address Text
To-Type To-Type Text

 

Notes:

  1. Text fields can be a single line of text, or multiple lines of text . 
  2. The Default Column Name refers to the display name of the SharePoint column.

The name of the email configuration file must be ColligoMappingConfig.xml. The file must be stored in the following locations, depending on your product version:

  • 6.x:
    • C:\Users\%username%\AppData\Roaming\ColligoOfflineClient\Config
    • C:\Users\%username%\AppData\Local\ColligoOfflineClient\Config
  • 7.x
    • C:\Users\%username%\AppData\Local\ColligoOfflineClient\Config

To adjust the SharePoint metadata column name for a particular message field, change the appropriate mapping element of the SharePoint Column attribute. Note that it is possible to specify multiple mappings for the same message field; that is, the same field can be mapped to multiple SharePoint metadata columns. The format of the file is shown below. 


 

xml
zip
stp

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
Have documentation feedback? Send us an email