range of data

  • Thread starter Thread starter tom
  • Start date Start date
T

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!
 
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
 
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??
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

name the range of data 3
How do you name "range" of data to import/export? 2
Contacts from Excel to Outlook 1
importing contacts from excel to Outlook error 2
Naming a Data Range 2
Naming Ranges for data exporting 1
Error message when importing to Outlool 2
how do I name a range of data in excel to export to outlook 2

Back
Top