Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to import into Outlook some names and addresses from Excel.. Why
does Outlook need a named range in that spread sheet? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Because you could have multiple sheets in a workbook, Outlook needs to know
where to find the data. To name a range, select the range and InsertNameDefine. Alternative.......copy the worksheet with the names and addresses to a new workbook and save as *.txt or *.csv file. Use that file as the source file for importing to Outlook Gord Dibben Excel MVP On Fri, 16 Dec 2005 06:36:02 -0800, GDB026 wrote: I am trying to import into Outlook some names and addresses from Excel.. Why does Outlook need a named range in that spread sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
issue with excel 2003 data import | Excel Discussion (Misc queries) | |||
Array to named range conversion... | Excel Discussion (Misc queries) | |||
Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
Importing data from Excel to Outlook | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |