Outlook 2003, import contacts from Excel

[gpan123]

hi,

I try to import contacts from Excel but I get an error message
(the records are in columns, each column a field)...

In addition I tried something else:
1) I create a record in Contacts
2) Export this in a Excel file
3) Pasted the records from my file
4) Import in Outlook
5) PROBLEM. Only the first record was imported

to overcome this I created 180 Contacts and again steps 2,3,4,5
and it was ok....

This doesn't seem right is there any other way, method. Some rules and conditions i should know?

 

[technokid88]

http://office.microsoft.com/en-gb/assistance/HA010964231033.aspx this is the steps microsoft gives out.

 

[gpan123]

I tried those steps (there is no other way) but in my case it doesn't seem so simple.

 

[technokid88]

Not sure why it didn't work, dont know about any other way of doing it

 

[madmatt]

In Excel, are you using unformatted text and saving the information as a CSV?

 

[fitz]

it would probaby be a little more helpful if you gave us the error message that came up..

 

[gpan123]

the error message i get in the first case is about "name ranges"

no, i don't use CSV...

all cells are in General format

 

[gpan123]

listen to this!!!! Strange.!!???

I export a category in an Excel file, and send it to a friend. He made some changes and delete some Columns....

...and guess what? I couldn't import the new file (with allow duplicates ON)