Importing contacts from excel into outlook contacts

[Ceoinva]

I have created an excel spreadsheet of contacts -- across the top row I have first name, last name, title, street address, city, state, zip, email, fax -- and am unable to import the list into Outlook.

Help said the fields needed to be named do I went in and think I did that one at a time -- clicked on the cells one at a time and added them...

then I went to import them into excel and I kept getting the message that the file I was trying to import was the wrong file type...

please help!

I don't really care what format the files start in just as long as I can get them into my contacts list...I would happy to create the source file in something else...text...word...etc...if that will make my life easier

Thanks.

 

[Karl Timmermans]

Sounds like you added a "named range" for each cell.

Simple solution for you is to just save your file in CSV format and import
that into Outlook. By doing that you don't have to worry about Excel "named
ranges" if you're not familiar with them.

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

I have created an excel spreadsheet of contacts -- across the top row I

have first name, last name, title, street address, city, state, zip, email,
fax -- and am unable to import the list into Outlook.

Help said the fields needed to be named do I went in and think I did that

one at a time -- clicked on the cells one at a time and added them...

then I went to import them into excel and I kept getting the message that

the file I was trying to import was the wrong file type...

please help!

I don't really care what format the files start in just as long as I can

get them into my contacts list...I would happy to create the source file in
something else...text...word...etc...if that will make my life easier

 

[Cornet]

You need to create a single Named Range covering the all cells in your
spreadsheet.

I have created an excel spreadsheet of contacts -- across the top row I

have first name, last name, title, street address, city, state, zip, email,
fax -- and am unable to import the list into Outlook.

Help said the fields needed to be named do I went in and think I did that

one at a time -- clicked on the cells one at a time and added them...

then I went to import them into excel and I kept getting the message that

the file I was trying to import was the wrong file type...

please help!

I don't really care what format the files start in just as long as I can

get them into my contacts list...I would happy to create the source file in
something else...text...word...etc...if that will make my life easier