Automatically Save Email Headers in SharePoint and Teams Columns Using harmon.ie Classic

harmon.ie’s email header mapping ensures that key information from your emails – like subject, sender, recipients, and sent date – is automatically extracted and saved as metadata when you save an email into SharePoint, Teams, or OneDrive. This makes it easier to organize, classify, and find important emails later, without requiring manual tagging.

By mapping email headers to predefined metadata fields, harmon.ie helps your organization maintain consistency, improve searchability, and support compliance – right from Outlook.

How to define email header mapping?

There are two ways to define email header mapping in harmon.ie Classic:

  1. Automatic email header mapping (available in harmon.ie Classic 9.5 and later):
  2. Customized email header mapping via SharePoint Web UI:
    • Supports custom columns and non-standard column and content type names
    • Recommended if your document libraries already include Email views or email columns
    • Requires Microsoft 365 admin assistance
    • Requires customizing email header mapping in New harmon.ie (if using a mix of harmon.ie Classic and New harmon.ie)

Automatic email header mapping (harmon.ie 9.5+)

Users should have a minimum permission of Edit to be able to create an Email view in the Microsoft 365 location.

When users upload an email message to SharePoint, Teams, or OneDrive, harmon.ie looks for an existing Email view in the library. If one is found, harmon.ie maps the email’s headers into metadata columns.

harmon.ie's Email View

If no Email view is present, harmon.ie can prompt the user to create one. You can control whether and where this prompt appears.

Prompt options:

  • Teams and SharePoint
  • Teams (default)
  • None

How to control whether and where harmon.ie prompts to create an email view

  1. Users can control this setting in the harmon.ie options.
  2. Administrators can centrally manage this setting to all users using the AutoEmailHeaderMappingBehavior provisioning key. [Download reg key sample]

If approved, harmon.ie will automatically create:

  • An Email view
  • An Email content type
  • The following email metadata columns:
Email Column Type Description
From Single line of text Sender’s address
To Single line of text Primary recipients
CC Single line of text Carbon copy recipients
Subject Single line of text Email subject line
HasAttachments Single line of text Indicates if the message has attachments. The default value should be “No”
Date Date and Time Sent date and time
Conversation Topic Single line of text A harmon.ie-specific column used for grouping emails
Conversation Index Single line of text Unique conversation identifier
Mail Preview Data Multiple lines of text A harmon.ie-specific column that enables previewing email messages in harmon.ie
  • harmon.ie will not create an Email view if the library is already configured for email header mapping.
  • If the site or site collection is configured but the specific library isn’t, users will be prompted to contact their admin.

Limitation: harmon.ie uses the language set in the harmon.ie sidebar, not the SharePoint site language, when creating metadata columns.