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

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

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

Nothing except to write a little VB code to change the phone numbers.

See http://www.outlookcode.com to see if there is already some code you can
use or customize for your purposes.

--
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


After furious head scratching, John asked:

| 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

"John" wrote in message
...

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?

This tool should be able to handle that:
http://www.slovaktech.com/phonechanger.htm
--
Brian Tillman [MVP-Outlook]

guys,
how would I use this. Do I need VB6, I only have Visual Studio 2008 and
this will not upgrade.?

Any ideas

Regards

John

"Brian Tillman [MVP - Outlook]" wrote in message
...
"John" wrote in message
...

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?

This tool should be able to handle that:
http://www.slovaktech.com/phonechanger.htm
--
Brian Tillman [MVP-Outlook]

John,

Try Find and Replace component from MAPILab Toolbox. It's an Outlook add-in.
You just have to set up a rule for replacing data and all information will be
instantly updated.

http://www.mapilab.com/outlook/toolb...d_replace.html

This component was developed for similar purposes.
--
Nick Kharchenko, MAPILab Ltd.
Software for Microsoft Exchange and Outlook


"John" wrote:

guys,
how would I use this. Do I need VB6, I only have Visual Studio 2008 and
this will not upgrade.?

Any ideas

Regards

John

"Brian Tillman [MVP - Outlook]" wrote in message
...
"John" wrote in message
...

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?

This tool should be able to handle that:
http://www.slovaktech.com/phonechanger.htm
--
Brian Tillman [MVP-Outlook]

guys,
how would I use this. Do I need VB6, I only have Visual Studio 2008 and
this will not upgrade.?

Any ideas

Regards

John
"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