Thread: Batch Update
View Single Post
  #3  
Old April 12th 09, 09:42 PM posted to microsoft.public.outlook
John[_26_]
external usenet poster
 
Posts: 4
Default Batch Update

Milly,

This method you suggest will not work as the format of the details exported
is "General" with a " ' " infront of the details exported. When you apply a
custom format it is no longer general and when you import back into outlook
the formatting is ignored and is displayed as a number.
When displayed like this, outlook misses off the +44 (0) at the begining of
the phone number and display it as 1234 567890 (dropping the 0) instead of
+44 (0)1234 567890

Any ideas?

Regards

John


"Milly Staples - MVP Outlook" wrote in message
...
You can export to Excel and set the column formatting to accomplish what
you want, then import them back to Outlook.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375


"John" wrote in message
...
Hi,
Can anyone tell me if it is possible to carry out a batch update of
contacts.
I have over 2000 contacts and would like to format their telephone
numbers.
At the moment all the nember are in the format 09999 999999 I need to
format them using +44(0)9999 999999
can this be done as a batch?

Regards

John


Ads