|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
April 28th 06, 06:32 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Exporting contacts- Phone Number changing!
I have exported a batch of contacts from Excel to Outlook. Everything
transfered fine except the phone numbers. They somehow changed from 10 characters to 9, and the numbers all changed, for example "507288xxxx" changed to "777114336"! Most of the "new" numbers begin with 777. Please help! 
|
|
#2
April 28th 06, 07:33 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting contacts- Phone Number changing!
Have run across a lot of strange things migrating data but this is a first.
#1 - Are your phone numbers in Excel exactly as you showed in your msg (i.e. no other chars like hyphens, * or /?) If not then it is possible your phone number field is being treated as a numeric field and recalculated on output but usually shows a different kind of value. #2 - If you save your Excel worksheet as CSV - are the phone numbers correct? #3 - If the CSV file is correct - simply import that file instead and you should be OK. If not - you have an Excel issue that needs to be resolved first. Karl __________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2003" http://www.contactgenie.com "KC" wrote in message ... I have exported a batch of contacts from Excel to Outlook. Everything transfered fine except the phone numbers. They somehow changed from 10 characters to 9, and the numbers all changed, for example "507288xxxx" changed to "777114336"! Most of the "new" numbers begin with 777. Please help!
|
|
#3
April 28th 06, 07:41 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Exporting contacts- Phone Number changing!
Karl,
Exporting the file as a .csv solved it. (Sorry the first time I tried it I had made a mistake and it didn't transfer right so I thought it wasn't working). Thanks for your help! "Karl Timmermans" wrote: Have run across a lot of strange things migrating data but this is a first. #1 - Are your phone numbers in Excel exactly as you showed in your msg (i.e. no other chars like hyphens, * or /?) If not then it is possible your phone number field is being treated as a numeric field and recalculated on output but usually shows a different kind of value. #2 - If you save your Excel worksheet as CSV - are the phone numbers correct? #3 - If the CSV file is correct - simply import that file instead and you should be OK. If not - you have an Excel issue that needs to be resolved first. Karl __________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2003" http://www.contactgenie.com "KC" wrote in message ... I have exported a batch of contacts from Excel to Outlook. Everything transfered fine except the phone numbers. They somehow changed from 10 characters to 9, and the numbers all changed, for example "507288xxxx" changed to "777114336"! Most of the "new" numbers begin with 777. Please help!
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why can't I search by phone number in Outlook 2003 contacts no | Ngwane | Outlook - Using Contacts | 0 | April 5th 06 03:00 PM |
| Exporting OL2k contacts so street number and name go into different fields? | David Tong | Outlook - General Queries | 5 | February 14th 06 03:52 PM |
| How do you link a phone number to a calendar contact | tssrjh | Outlook - General Queries | 1 | February 6th 06 04:52 PM |
| how to Set Primary phone number in Outlook? | Junaid | Outlook - Using Contacts | 0 | February 3rd 06 07:09 PM |
| Default phone number | Collin van Rooyen | Outlook - Using Contacts | 1 | January 26th 06 03:00 PM |
Hybrid Mode
