Community
Showing results for 
Search instead for 
Do you mean 
Reply

How do I auto change 2,000 contacts at once from excel?

Skilled Commentator
Posts: 98
Country: Australia

How do I auto change 2,000 contacts at once from excel?

Hi,

 

I have a list of about 2,000 email opt outs frpom Swift Page from over the last few years.  All I have is the email list in excel of opt outs, this list doesn't have the persons name like ACT does.  We haven't updated these on ACT as we've just always let them bounce. However now I want to.  What's the best way to auto upload this so we don't have to manually do each one? Ideally it would be to have the Subscribe to newsletter field change to Opt Out, but if need be it could delete the email. Fine if the best solution is an add on.  I think I can probably do this by importing the emails and having another excel column for opt out, however as this is a dramatic change to our database I want to be on the safe side and check if there's a better/safer way?

 

Thanks!

 

Scott Hunt

Fitness Enhancement

Copper Elite Contributor
Posts: 232
Country: Germany

Re: How do I auto change 2,000 contacts at once from excel?

Hi Scott,

 

you can do this with our Import-it, it allows to search a contact with i.e. email adress and then update a field like a opt Out checkbox

 

https://kayako.crmaddon.com/index.php?/Knowledgebase/Article/View/216/0/how-to-update-contacts-by-em...

 

this is the link to the manual, of import-it 

 

regards

 

Ingo Lange

 

ACC since 1995
Developer of Addons for ACT

CrmAddon Factory
+1 203 541 0040
Silver Contributor
Posts: 1,813
Country: USA

Re: How do I auto change 2,000 contacts at once from excel?

Also take a look at oak merge. THeir Basic edition should do the trick for you.

 

http://www.oakmerge.com/Basic-Edition-Data-import-tool.html

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider