Need method to rapidly correct telephone contact telephone number formatting

Status
Not open for further replies.

austxus

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Users have desire to format their phone numbers in (xxx) xxx-xxxx format. Currently most of them look like xxxxxxxxxx. Since most users have between 1000 and 4000 contacts, manually is not an option. What is best way to quickly format the phone numbers.ThanksTom
 

catherized

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server 2010
Re: Need method to rapidly correct telephone contact telephone number formatti

What country/location do you have configured in Control panel, phone and modem options? That controls the phone number format. I don't think that will fix the existing numbers, I think you'll need to 'touch' each number.

Someone else might have a better solution, but if you need to touch the numbers, try a variation of the marco at http://www.slipstick.com/outlook/contacts/bulk-move-phone-numbers-to-a-different-phone-field/ and instead of moving it to a new field, move it to its own field.

Something like

If .OtherTelephoneNumber <> "" Then
.OtherTelephoneNumber = .OtherTelephoneNumber.Save

End If
 
Status
Not open for further replies.
Top