Outlook Contacts - Move "other" field to "mobile" field - can I automate?

A client has just moved from a Nokia to iphone and we are for the first time for this user synchronising his contact / emails with the exchange server.

We manually imported into Outlook his existing Nokia contacts (about 1000) which was achieved using the Nokia software and we had them placed into a subfolder within his Outlook contacts (called "Mobile Contacts" as opposed to the already 3000 or so contacts that already were within OUtlook)

The problem is, getting the contacts from the Nokia to Outlook has resulted in the actual important mobile / cell number being placed into the Outlook contacts "other" field in about 70% of cases.

The further problem is that the iphone wont display this information contained within the Outlook "other" field, resulting in the user not having any actual mobile numbers for the majority of his contacts.

Frustrating! I can fix this by login into his Outlook and for each contact simply moving the mobile /cell number from the "Other" field, into the "Mobile" or any other primary phone field (e.g. "home Phone").
But I don't really want to spend my Saturday doing this for about 700 contacts.

Is there an automated way of looking at a contact and moving the "other" data to the "Mobile" field data (only when the mobile field data is empty - remember some of the contacts seem to be OK)

Many thanks for any input on this.

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:
You can export the contacts to a CSV file, open the file in Excel, manipulate the Other Field / Mobile Field and then import the contacts back.

Before you import, I would move the contacts in Outlook into a new contacts folder so that when you import, if it goes wrong, you can delete them and start again and you still have your original contacts intact as a backup.

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
Use this simple powershell script to solve this task. This is a script you will have to run on the computer were Outlook with these contacts are..

Just code the code snippet into the powershell.

$outlook = new-object -com outlook.application
$contacts = $outlook.Session.GetDefaultFolder(10)
$contacts.Items | % { if($_.MobileTelephoneNumber -eq "") { $_.MobileTelephoneNumber = $_.OtherTelephoneNumber; $_.OtherTelephoneNumber = ""; $_.save() } }

Open in new window

afflik1923Author Commented:
I never tried the coding solution as I started implementing the Excel one which worked great (in particuar because in practise there were other things that needed fixing)

Code looks good however.
The powershell solution works great. Any way to do on XP machine that does not have  powershell?
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.