OL2003 mapping custom fields for import of Excel contacts

[Guest]

Hi!

Even though I named the ranges in my excel workbook, I cannot properly
import excel contacts into Outlook. Not even when the excel data was
originally exported from Outlook! In the import dialog box, the actions to be
performed field shows not 1 excel file to import, but al the column headers
of the file as seperate item. I can only map custom fields per item. The
result of such import is very strange.

I found out converting the excel file first in an access db and than
importing that access file in Outlook contacts, is an easy work around. But I
get really sick of not knowing what went wrong importing the excel file. Or
didn't I correctly named the ranges in Excel? I followed up all instructions
here posted about naming ranges...

Can anyone clear up my mysterie?

Regards, Esther

 

[Guest]

Ranges, as in plural? Maybe that's the problem. You need only one named range
for the import. It should include both all the data and the column headings.

 

[Guest]

Sue, I got the result requested by selecting the whole range, using the Excel
command: Insert - Name - Define..
Somewhere previously in the newsgroup your instruction was posted: Insert -
Name - Create.., but in that case I was never able to name the whole range..

Anyhow.. problem finally solved.
Thanks for putting me on track!
Esther