Best way to mass change email addresses?

[Jose_Rafael_Par]

Hi everyone,

My company just changed our domain name, and we use marketo for all employee notifications. I'd like to change the email addresses on the lead records for our employees to the new one, and I was wondering if there was a better way to do that than manually going through every record. Normally to make a change like this, I would export all of the fields that need changing along with their email address and then reimport the list after making the changes, so that marketo matched the email addresses and updated the fields in the spreadsheet, but since these are different email addresses, I don't know how to get Marketo to not create new leads instead of just updating the old ones.

Any ideas?

Thanks!

[Anonymous]

I'd do this in SFDC using the Lead or Contact ID # as the matching method.

You might be able to do something similar using the Marketo ID, but test that on 1 record first.

[Anonymous]

Another option would be to create Smart Lists in your Lead Database. Each rep should have their own smart list dictated by "Lead Owner Email Address". Then, one rep at a time, as long as the new rep email addresses are already updated in SFDC and Marketo, you can simply select all and do a "Change Owner...".  But like Josh recommended, I'd definitely test on one record to start.