Link to home
Start Free TrialLog in
Avatar of Cathalfp
Cathalfp

asked on

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?
Avatar of Alan Hardisty
Alan Hardisty
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Avatar of Cathalfp
Cathalfp

ASKER

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
I would have to agree with alanhardisty with exporting them to a csv and updating the address and redump them back in.
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.
SOLUTION
Avatar of Alan Hardisty
Alan Hardisty
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial