If you have a Salesforce contact or lead with many email addresses and want to load them into Mailchimp, the best option is to use the data wizard.
As an example, if you wanted to add one Salesforce contact with two email addresses to the same Mailchimp audience, you could use these steps:
- Create two Salesforce reports containing the fields you need. Ensure each report includes one of the email addresses (e.g., personal email in the first report and work email in the second).
- Use the data wizard to create an import schedule for the first report. Then create another import using the wizard for the second report. Running both imports will create two audience members, each with one of the two emails.
- Update the Mailchimp to Salesforce matching rules to include any emails for which you made separate imports. Configuring matching is explained in Field Mappings.

