Using email site columns
Who is this article for?
Users who want to learn to use email site columns.
No elevated permissions are required.
This article explains how to configure email metadata columns in SharePoint for improved classification, search, and enterprise content management.
1. Add email site columns to the SharePoint site
Several columns are available to ensure that email metadata is captured at the time of saving to SharePoint.
Email columns can be deployed using the administration client for efficient setup of columns, content types, and views in your site and document libraries.
Note: The administration client does not support email content type deployment to non-English SharePoint sites or to subsites unless the parent site has already been configured.
1.1. Launch the administration client
This process does not currently support adding columns to the content type hub. To add columns to the content type hub, please contact support at support@oneplacesolutions.com.
1.2. Steps to deploy email columns
- Select add email columns from the left pane.
- Select the location to add the email columns. Options include:
- Specific libraries (SharePoint and Teams) within the site collection
- If the site collection does not appear, select Add a site collection and paste in the URL
- For private Teams channels, use the SharePoint URL for the channel and add it as a SharePoint site collection
- For subsites, ensure the email site content type exists at the site collection level first
- Select Add.
- Once all sites and libraries are selected, click Next.
- Select yes to allow content type management.
- Select an existing content type or create a new one named email (recommended).
- Choose whether to create a view. The view will include:
- Email has attachment
- Email date
- Email subject
- Email from
- Email to
- Select Deploy.
- Confirm the results and select Finish.
Note: Any red rows in the results indicate an error. Click the row for more details.
2. Manually create the email columns
If needed, columns can be manually created as site columns in the site collection. These must use the internal names listed below and can be renamed for display purposes. Columns are case sensitive.
2.1. Available email columns
| Column name | Column type |
|---|---|
| EmSubject | Single line of text |
| EmTo | Multiple lines of text |
| EmToAddress | Multiple lines of text |
| EmCC | Multiple lines of text |
| EmBCC | Multiple lines of text |
| EmFrom | Single line of text |
| EmFromName | Single line of text |
| EmDateSent | Date and time |
| EmDateReceived | Date and time |
| EmDate | Date and time |
| EmID | Single line of text |
| EmAttachCount | Single line of text |
| EmAttachmentNames | Multiple lines of text |
| EmCon | Single line of text |
| EmConversationID | Multiple lines of text |
| EmConversationIndex | Multiple lines of text |
| EmCategory | Single line of text |
| EmBody | Multiple lines of text |
| EmSensitivity | Number |
| EmImportance | Number |
| EmToSMTPAddress | Multiple lines of text |
| EmCCSMTPAddress | Multiple lines of text |
| EmBCCSMTPAddress | Multiple lines of text |
| EmFromSMTPAddress | Multiple lines of text |
| EmHasAttachments | Yes/No |
| EmSentOnBehalfOfName | Single line of text |
| EmReceivedOnBehalfOfName | Single line of text |
| EmCompanies | Single line of text |
| EmRetentionPolicyName | Single line of text |
| EmReplyRecipientNames | Single line of text |
| EmReplyRecipients | Single line of text |
| DocCreatedSaved | Date and time |
| DocModifiedSaved | Date and time |
3. Add the email columns to a content type
The following instructions detail how to:
- Create the email content type and add site columns.
- Add the content type to a document library.
- Create an email view on the library.
3.1. Create email content type
- Open site settings and navigate to site content types.
- Name the content type.
- Open the newly created content type and add columns from existing site columns.
- You can now use this content type in any library inside your site collection.
3.2. Add the content type to document libraries
- Browse to the document library.
- Select Library settings.
- Select Advanced settings.
- Set Allow management of content types to yes and select OK.
- Under Content types, select Add from existing site content types.
- Select the previously created email content type and click add, then OK.
3.3. Create the view for email columns
- Select Library settings.
- Scroll down to Views.
- Select the default view or create a new view.
- Select the email columns to be added to the view.
- To show the paperclip icon for attachments, ensure the
EmHasAttachmentscolumn is added. - Select OK.
The columns will now be visible. When saving an email to the library, the email attributes will be captured and displayed.