OL2003 mapping custom fields for import of Excel contacts


G

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
 
Ad

Advertisements

G

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top