Logo

How can I automatically map email message properties?

This article applies to:
EMO MS365 Email Manager add-in
8.x Email Manager for Outlook
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 MetadataDefault Column NameType
AttachmentAttachmentYes/No
BccBccText
Bcc-AddressBcc-AddressText
Bcc-TypeBcc-TypeText
CategoriesCategoriesText
CcCcText
Cc-AddressCc-AddressText
Cc-TypeCc-TypeText
ConversationConversationText
FromFromText
From-AddressFrom-AddressText
From-TypeFrom-TypeText
ImportanceImportanceNumber
ReceivedReceivedDate/Time
Received-UTCReceived-UTCDate/Time
SensitivitySensitivityNumber
SentSentDate/Time
Sent-UTCSent-UTCDate/Time
SubjectSubjectText
ToToText
To-AddressTo-AddressText
To-TypeTo-TypeText

 

Additional Notes (V7 and V6):

  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