Gord: Thanks. Help me more. Do I "select' by simply highlighting the cell
area? When I go to "insert" on the tool bar/ribbon, I do not see
namedefine??

"Gord Dibben" wrote:

In your Excdel workbook select the range of names/addresses/phones and
InsertNameDefine

Give the range a name like MyList

Save and close the workbook.

Open Outlook and run through your import.


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 08:50:02 -0800, tom wrote:

using Excel and Outlook 2007. Trying to import into Outlook set of
names/addresses/phones from Excel. In Outlook get message to use Excel to
set a "range of data" to import. Can you tell me how to do that in Excel?
Thanks in advance!