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.
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:
