M
Milly Staples [MVP - Outlook]
Create a new contact folder and populate it with a few names/numbers, etc.
Export this to a .csv. Open the .csv and compare it to the one from which
you are trying to import and massage the fields accordingly. Ensure that
you have no formulas set to operate in the Excel worksheet you are using.
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Gio Bacareza asked:
| I'm having problem importing contacts from Excel to Outlook. The
| problem happens with phone numbers. The Outlook translator subtracts
| 8589934592 from the original phone number. For example. if i have
| 9177934249 in Excel, once imported the number becomes 587999657 when
| displayed in Outlook.
|
| Is this a bug? What's the fix?
|
| Also, when exporting contacts from Outlook to Excel, the output for
| phone numbers (business, fax, mobile, etc) is 0.
|
| Again, bug? what's the fix?
|
| Thanks
Export this to a .csv. Open the .csv and compare it to the one from which
you are trying to import and massage the fields accordingly. Ensure that
you have no formulas set to operate in the Excel worksheet you are using.
--
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Gio Bacareza asked:
| I'm having problem importing contacts from Excel to Outlook. The
| problem happens with phone numbers. The Outlook translator subtracts
| 8589934592 from the original phone number. For example. if i have
| 9177934249 in Excel, once imported the number becomes 587999657 when
| displayed in Outlook.
|
| Is this a bug? What's the fix?
|
| Also, when exporting contacts from Outlook to Excel, the output for
| phone numbers (business, fax, mobile, etc) is 0.
|
| Again, bug? what's the fix?
|
| Thanks