range of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tom - 31 Jan 2008 16:50 GMT

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!

Reply to this Message

Gord Dibben - 31 Jan 2008 18:04 GMT

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

>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!

Reply to this Message

tom - 31 Jan 2008 19:10 GMT

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

> In your Excdel workbook select the range of names/addresses/phones and
> Insert>Name>Define
[quoted text clipped - 11 lines]
> >set a "range of data" to import. Can you tell me how to do that in Excel?
> >Thanks in advance!

Reply to this Message

Gord Dibben - 31 Jan 2008 21:01 GMT

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

>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
[quoted text clipped - 15 lines]
>> >set a "range of data" to import. Can you tell me how to do that in Excel?
>> >Thanks in advance!

Reply to this Message