How to Mass Import Historical Emails into Salesforce?

I’m deploying a new SF org.
I’ve got hundreds of past email threads with customers I want to “import” to SF and have these emails appear as activities under the Account/Case record.
Is there any way to achieve that?

I thought of using email-to-salesforce and FW the emails to the designated email address but the email will be filed under unresolved items instead of under the Account

Answer

My understanding is that you need to include a reference to the Account or Case you want the activity history to be associated with.

So when you forward the existing emails you need to put ref: 001D0000000HQZy into either the email subject line or body. Here 001D0000000HQZy is the 15 character Salesforce Id for an Account. You can get the required Ids from the URLs when viewing individual records.

Without that reference Salesforce will add the emails to the “My Unresolved Items” page.

See the Adding Email with Email to Salesforce documentation.

Failing that, you could use something like the Data Loader to directly create the required Task records from a CSV export of the emails.

Attribution
Source : Link , Question Author : Dedo , Answer Author : Daniel Ballinger

Leave a Comment