Community
Showing results for 
Search instead for 
Do you mean 
Reply

Bulk change e-mail domain?

Copper Contributor
Posts: 21
Country: United States

Bulk change e-mail domain?

[ Edited ]

Recently a company I deal with regularly changed its domain from x.ca to x.com. I have hundreds of contacts at this company. Is there a way I can bulk change firstlast@x.ca to fisrtlast@x.com? Using Act! 2012 and not interested in buying addons.

 

Thanks!

Moderator
Posts: 719
Country: USA

Re: Bulk change e-mail domain?

There is not a way to do this in Act! itself. However, you can use Act! to export just that list of contacts to Excel, do a find and replace in Excel based off of the domain name, and then reimport it into the act database. A couple of things you would want to do before doing this:

 

  • Make sure that you create a backup of your database before hand
  • Make sure that your duplicate checking settings do not contain the e-mail address for this import, as the e-mail address will be different when you reimport, which will cause duplicates
  • Make sure that the excel file contains only the email address field and any fields you use to duplicate check on before you import the names back in
  • Make sure that you choose the custom import option, and specify the merge options to replace with source contact

 

For more information on duplicate checking and exporting and importing into excel see the Knowledgebase articles below:

 

How To Set Duplicate Checking Preferences in Sage ACT!

How to Export Act! Data to Microsoft® Excel®

How to Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into ...

 

 

 

Elise O'Pry
Swiftpage
Visit our knowledgebase at http://kb.act.com