| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
range of data
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
range of data
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
range of data
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
range of data
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 InsertName is located on the Insert menu on the Worksheet Menu Bar Insert**FormulasDefined Names** Gord On Thu, 31 Jan 2008 11:10:02 -0800, tom wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| How do I link data from a horizontal range to a vertical range? | Excel Worksheet Functions | |||
| Show Data In Range not appearing in Separate Range | Excel Discussion (Misc queries) | |||
| How do I change a range name back to the underlying data range? | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Linear Mode
