Save E-Mail header information in SharePoint Columns

By using out of the box SharePoint functionality, I didn’t found a good solution on how to extract e-mail header information like sent-date or recipient and save them in SharePoint columns. The only way it’s possible seems to be using a 3rd party tool.

Therefore i used the tool harmon.ie in combination with Lotus Notes. To get this done you can use the settings in Lotus Notes (i am sure the same is possible with Outlook client).

1. Activate harmon.ie sidebar

2. Go to File – Preferences

3. Choose harmon.ie and then e-mail setting

4. click on mapping

5.There you can see columns and its names which are mapped by default. You can simply add your custom column names. For example Date and From Mapping to the field.

After you save this settings you can simply drag and drop mails into the harmon.ie side bar and the information will be extracted.

And the result should look like this:

In SharePoint you see it like this:

Now after you are happy how it is working you should consider some afterwords steps:

Look what headers information can be mapped: https://harmon.ie/map-email-headers-sharepoint-metadata

And of course, how you can provision the settings to all your users very quickly und intelligent via registry settings: https://harmon.ie/KB/provisioning-notes

 

 

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.



Karsten Schneider
About Karsten Schneider 281 Articles
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

Be the first to comment

Leave a Reply

Your email address will not be published.


*