Batch Update

J

John

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
 
M

Milly Staples - MVP Outlook

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
 
J

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 said:
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 said:
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
 
M

Milly Staples [MVP - Outlook]

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

Brian Tillman [MVP - Outlook]

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
 
J

John

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
 
J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top