Community
Showing results for 
Search instead for 
Do you mean 
Reply

how to replace duplicates with new information

New Member
Posts: 22
Country: USA

how to replace duplicates with new information

Hi,

 

I have some new information(e.g Email address) for some contacts which are already in the database. Does anyone know how to import the new information the contacts? At first, I think maybe I can export these contacts to excel, add the new information and then import them to the database. But by doing this, the created date will change and notes may lose. Any ideas? Thanks.

 

Roy

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: how to replace duplicates with new information

Your best choice is to use the addon Oakmerge.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: how to replace duplicates with new information

New Member
Posts: 22
Country: USA

Re: how to replace duplicates with new information

I need to create email address for all the contacts. The format would be "first name.last name@abc.com". I export contacts to excel and use functions to create emai addresses. All I need to do is to add all the email addresses to the database. Thanks.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: how to replace duplicates with new information

I'd doubt that many of the email addresses would be correct ... why would you do that, not knowing if they're accurate?
New Member
Posts: 22
Country: USA

Re: how to replace duplicates with new information

I talked to someone in that company and he said this is the email address format for  his department. So I think it would be correct.

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: how to replace duplicates with new information

How many contacts in that dept?

Even if it's default format, will also be exceptions... eg people with same name