Because you could have multiple sheets in a workbook, Outlook needs to know
where to find the data.

To name a range, select the range and InsertNameDefine.

Alternative.......copy the worksheet with the names and addresses to a new
workbook and save as *.txt or *.csv file.

Use that file as the source file for importing to Outlook


Gord Dibben Excel MVP


On Fri, 16 Dec 2005 06:36:02 -0800, GDB026
wrote:

I am trying to import into Outlook some names and addresses from Excel.. Why
does Outlook need a named range in that spread sheet?