Outlook contact issues, Primary Address Changed - Home address vs Business address showing after migration

Good morning All,

Thanks for any help you can provide on this.

I have a client which we did a RackSpace to Office 365 migration through SkyKick. The migration went well except to one odd thing. The end user had all his contact addresses switch from Business as primary address to Home as primary.

He has about 3500 contacts, so I am looking for a way to do a bulk change on the primary address either on the desktop Outlook side or on the hosted O365 side which ever will work.

Again, thank you for any help someone can provide.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Vasil Michev (MVP)Commented:
Are those personal contacts (i.e. stored in his mailbox People folder) or company-wide ones (i.e. stored in the GAL)? In the later scenario, you should be able to bulk change this via PowerShell. But since you mentioned business and home address, it seems to be the first case, in which case you should look into some VBS macro.
CMITStamfordAuthor Commented:
Thank you Vasil,

Yes - I worked with MS support and determined that they are in the Outlook client Personal contacts only. I now need to find code to fix this. If you have any suggestions they wound be much appreciated.

Thanks again,

Vasil Michev (MVP)Commented:
Not really a VBA guy, sorry. I have a general idea on what the macro should look like, but it's best if you ask for help in a specialized group/forum. For example, try the VB group here: http://www.experts-exchange.com/Programming/Languages/Visual_Basic/

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
CMITStamfordAuthor Commented:
ok - thanks for your help!
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

From novice to tech pro — start learning today.