importing contacts from Excel into Outlook 2002

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 06 Mar 2005 19:01 GMT

My import goes well execpt for the phone and fax numbers. The import is
completed but the phone and fax numbers I get in my Outlook contacts bear no
resemblance to the numbers from my Excel spreadsheet. I have no idea where
they're coming from. What am I doing wrong? Thanks

Reply to this Message

Karl Timmermans - 06 Mar 2005 22:37 GMT

From your description - the most likely cause of the issue that your
encountering is that your phone numbers are being interpreted as "numeric"
fields and the strange result is actually the "value" of the phone number.

Suggest that you change your Excel columns to text and if that doesn't work
another way to get around it is to simply save your Excel file in CSV format
and import that file.

Karl

Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

> My import goes well execpt for the phone and fax numbers. The import is
> completed but the phone and fax numbers I get in my Outlook contacts bear
> no
> resemblance to the numbers from my Excel spreadsheet. I have no idea
> where
> they're coming from. What am I doing wrong? Thanks

Reply to this Message

Mike - 07 Mar 2005 01:35 GMT

Thanks Karl. I tried changing the columns to text with no luck. I still
can't figure out where it came up with the numbers it did. But when I saved
my Excel workshheet as a CSV file the import went through with no problem.
Thanks again.

Mike

> From your description - the most likely cause of the issue that your
> encountering is that your phone numbers are being interpreted as "numeric"
[quoted text clipped - 11 lines]
> > where
> > they're coming from. What am I doing wrong? Thanks

Reply to this Message