range of data

[tom]

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!

 

[Gord Dibben]

In your Excdel workbook select the range of names/addresses/phones and
Insert>Name>Define

Give the range a name like MyList

Save and close the workbook.

Open Outlook and run through your import.


Gord Dibben MS Excel MVP

 

[tom]

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
name>define??

 

[Gord Dibben]

That's what I get for not reading posts thoroughly<g>

I don't use 2007 but Ron de Bruin has a "where to find" for 2007.

http://www.rondebruin.nl/0307commands.htm

Looks like Insert>Name is located on the Insert menu on the Worksheet Menu Bar

Insert>**Formulas>Defined Names**


Gord