Importing contact details from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import a file from Excel to Outlook contacts. But the
following window keeps appearing: ... the microsoft Excel file has no named
ranges. Use Microsoft Excel to name the range of data you want to import. In
response, I have followed previously provided advice - namely: Select the
range of cells in Excel that you want to import (say, from A1 to J12) and
while that block is selected, type a name for the range in the box above the
grid, to the left of the formula bar (it usually has a cell number in it and
if you hover over the box it should say Name Box). Now save and close the
spreadsheet and try to import from Outlook again. BUT after doing so, and
starting the import process, I still get the same "the microsoft Excel file
has no named ranges message". I am going around in a circle. All suggestions
would be gratefully appreciated.
 
did you check to make sure the named range is getting saved? you can check
by looking in the insert > name > define menu.
 
Back
Top