Modify Outlook Contact Telephone Numbers to Add a 9

I have a problem where I am trying to find a way to use Cisco IP Softphone to dial the numbers held in Outlook 2003 contacts.

The problem is Outlook has the numbers stored without a 9 at the beginning. Is there a way to update ALL of the telephone numbers for ALL contacts so that the STD codes become prefixed with a 9. E.g. both (0114) and 0114 become 90114 and (07807) and 07807 become 907807.
Please note that some are local numbers so may not have an STD code although these could be added if they are a problem.
Also some are international numbers so have two leading zeros.

Yes, it's possible to prefix the numbers with a 9. It's unnecesary though. Outlook follows the dialing rules set in Phone and Modem Options in the Cotnrol Panel. One of the options you can set is the number to dial to get an outside line. If you specify a 9 for both local and long distance numbers, then Outlook should insert the 9 for you when it dials.

Numbers (For me anyway) are listed as 0114 555666 etc or 009 855 446766.
However, some put brackets around the STD code e.g (0114) 555666.
These need to be converted to all look like 90114555666 or 9009855446766 (Although having spaces should be ok so don't worry about removing them)
Is that enough info?
Many thanks!

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

1. Start Outlook
2. Click Tools > Macro > Visual Basic Editor
3. If not already expanded, expand Microsoft Office Outlook Objects
4. If not already expanded, expand Modules
5. Select an existing module (e.g. Module1) by double-clicking on it or create a new module by right-clicking Modules and selecting Insert > Module.
6. Copy the code from the Code Snippet box and paste it into the right-hand pane of Outlook's VB Editor window
7. Edit the code as needed. I included comments wherever something needs to or can change
8. Click the diskette icon on the toolbar to save the changes
9. Close the VB Editor
10. Select the folder containing the contacts you want to run this against
11. Run the macro FixPhoneNumbers

I recommend running this against a folder with some test contact first to make sure it works properly before running it against your full contacts folder.

Featured Post

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).

To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it.
The vast majority of email clients display l…

This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory.
NOTE: For Outlook 2016 and 2013 perform the exact same steps.
Open a new email: Click the New email button in Outlook.
Start typing the address: …