Alphonse wrote:

I have received and Excel file with Contact information; all the
headings, Title, First Name, etc. are correctly placed at the top of
each column, but when I try to import the xls file I receive a
message stating "The MS Excel file [path\filename] has no named
ranges. Use Excel to name the range of data you want to import."
I don't understand what it means by "named ranges"... I have looked
in XL but have not found anything that helps. Can someone please tell
me how to do this?

Did you look in Excel's Help? Here is a description from that Help:

Name cells in a workbook

You can use the labels of columns and rows on a worksheet to refer to the
cells within those columns and rows. Or you can create descriptive names to
represent cells, ranges of cells, formulas, or constant values. Labels can
be used in formulas that refer to data on the same worksheet; if you want to
represent a range on another worksheet, use a name.

You can also create 3-D names that represent the same cell or range of cells
across multiple worksheets.

Name a cell or a range of cells

Select the cell, range of cells, or nonadjacent selections that you want to
name.
Click the Name box at the left end of the formula bar .

Type the name for the cells. Press ENTER.
--
Brian Tillman [MVP-Outlook]