How to mass import emails in salesforce.com?

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 https://na5.salesforce.com/help/doc/en/email_my_email_2_sfdc_using.htm 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.

Dedo at Salesforce Visit the source

Was this solution helpful to you?

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.