Mass update address fields in shared contacts

We have a major client who is moving their offices. This clients employees number in the hundreds of our shared contacts and each entry will need to have the old mailing address updated with the new address. Is there a way to do this programmatically or a third party solution that would accomplish this?
CathalfpAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alan HardistyCo-OwnerCommented:
One way would be to Export the contacts to Excel, then do a Search and Replace in Excel and then Import them back again having deleted the original contacts from Outlook.

Alan
0
CathalfpAuthor Commented:
I am looking at a way to do this at the Exchange level. We are on Exchange 2010 and the addresses reside in a public folder of shared contacts.

Cathal
0
Nick RhodeIT DirectorCommented:
I would have to agree with alanhardisty with exporting them to a csv and updating the address and redump them back in.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

CathalfpAuthor Commented:
Thanks Alan and NRhode, but I don't see where I would export a public folder (shared contacts) that resides in Exchange to CSV.

From Outlook itself I can only export my own contacts (and we can do this for our users that may have these contacts in their own personal contacts) but we need to update the contacts in the Public Folder that is shared by users in three different offices and three different cities. I have read that this can be accomplished using Exchange Web Services but I can honestly say I have not used EWS before and would be hesitant to attempt this and risk messing up a folder that contains 6,000+ contacts in it without exploring all my options beforehand.
0
Alan HardistyCo-OwnerCommented:
You can create a local Folder for Contacts, copy the contacts from the Public Folder (or move them) to the local folder, export just that folder to a .CSV file, then open the .CSV file up in Excel, make the changes, import the contacts back to Outlook (to a separate folder or the emptied Contacts folder, then move the contacts to the Public Folder.

Job Done.
0
CathalfpAuthor Commented:
Thanks Alan - I will attempt that before I try anything in EWS! If this works I will let you know.

Appreciate the help on this.

Cathal
0
Nick RhodeIT DirectorCommented:
I understand completely.  The method that would be used is a little bit of a pain.  You would create a temp profile, copy the public folder contacts to local contacts > export them to csv, update it, reimport the updated contacts to outlook, push updated contacts to public.

Pretty fun stuff.  

The only thing I can think of is if you added an email policy to those contacts so they are all techincally the same "like username@domain.com".  If this is true there is an email policy assigned to them which can be adjusted or you can add the new address from the policy.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.