We help IT Professionals succeed at work.

Removing brackets from phone numbers in contacts outlook 2003

gopalpatel
gopalpatel asked
on
Medium Priority
638 Views
Last Modified: 2011-10-03
My client has around 4000 contacts in outlook but needs an instant way to clear out the brackets that outlook has automatically inserted into the phone numbers around area codes.  This is because its causeing problems with dialing the number from his mobile.  Is there some kind of script that can be run to do this automatically?

Many thanks

Gopal
Comment
Watch Question

Top Expert 2004

Commented:
Hi gopalpatel,

I would guess one method would be to export the contact list as MS access or excel file.
then open that exported file in excel or access and find and replace "[" or "]" with a blank space
Save the file and then import it back to outlook..

Thanks
Top Expert 2004
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Karen FalandaysTraining Specialist
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2004

Commented:
Thanks for the pts..

Thanks again karen for your smart idea
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.