Customers have the ability to associate Contacts with Multiple Accounts.
After an administrator has Set Up Contacts to Multiple Accounts, it's possible to add new contact and account relationships in mass using the Data Loader via the following steps:
| Warning Always back up your data before performing any data operation. See Export Backup Data from Salesforce or Export Data for more details. It is recommended to run a test with a small subset of records to ensure the operation was successful through manually opening and verifying that the corresponding records are correct in Salesforce. |
1. Prepare a CSV file with the following columns:
Contact Id - Ids of the contacts you wish to associate to multiple accounts.
Account Id - Ids of the accounts you'd like to associate to each contact row. Each contact / account relationship should be on a separate row. This means if you're associating 1 contact with 5 accounts, your spreadsheet should have 5 rows with the same contact id.
Roles - Optional. Available values can be found or set by navigating to Setup, enter Contact Roles on Accounts in the Quick Find box, then select Contact Roles on Accounts. You can specify multiple values by separating them with a semicolon. See Update multi-picklist field values using Data Loader for more details (Ex. "Business User;Decision Maker;Technical Buyer")
IsActive - Optional. Indicates whether relationship is active (true) or not (false).
Start Date - Optional. The date a relationship between a contact and account began. Used to keep a history of the relationship.
End Date - Optional. The date a relationship between a contact and account ended. Used to keep a history of the relationship.
Note: The format of the Start and End Date values in your file should be YYYY-MM-DD (Ex. "2017-12-01"). You may need to manually and explicitly set the format for each date column in Excel before saving your file. See Why do date fields import incorrectly when I use the Data Loader? for more details on how to format your data with: YYYY-MM-DD.
2. Populate the file with your desired contact and associated account record Ids as well as optional columns and their values and save.
An example CSV file, "AccountContactRelation Example.csv" is attached to this article to help you get started. NOTE: In the example file there is only 1 contact that's being associated to 3 different accounts for illustration purposes.
You can find existing Account and Contact record Ids by viewing records in Salesforce as outlined in the Unique Record IDs in Salesforce. Alternatively, Build a Report and Export a Report in Comma Delimited .csv format or alternatively use an API tool such as the Data Loader to Export Data by selecting to include Account and Contact Ids along with any other desired fields to identify your records.
3. Once satisfied with your prepared file, open Data Loader and select:
A) Insert | Login | Next
B) Click "Show all Salesforce objects" to locate and select "Account Contact Relationship (AccountContactRelation)" from the list. Click the "Browse..." button and choose the csv file you've created | Open | Next
C) Verify that the number of records in the prompt is correct and click OK. Click the "Create or Edit a Map" and then "Auto-Match Fields to Columns". Verify that the columns are appropriately matched to the Salesforce fields and click OK | Next
D) Click Browse... and select a location on your local machine for the resulting success and error files. Click Finish | Yes.
See Also :
Considerations for Relating a Contact to Multiple Accounts
000382467
0 KB

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.