| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What does it mean define ranges in Excell for import
I am trying to use an Excell database of names to be used in Outlook and it
asks for defining of ranges . Its a one column. I dont understand. Please help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
What does it mean define ranges in Excell for import
I believe MS Outlook is expecting a "named range".
See Debra Dalgleish's instructions on how to create one: http://www.contextures.com/xlNames01.html Does that help? *********** Regards, Ron XL2002, WinXP "Ron" wrote: I am trying to use an Excell database of names to be used in Outlook and it asks for defining of ranges . Its a one column. I dont understand. Please help |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
What does it mean define ranges in Excell for import
Ron
One column with just names? Select and InsertNameDefineAdd. Give the range a name like MyRange and OK your way out. If the one column is more than a list of names you may have to re-arrange. i.e. Name Address email address would have to go into separate columns with headers Name Address Email Address Gord Dibben MS Excel MVP On Thu, 7 Sep 2006 09:09:03 -0700, Ron wrote: I am trying to use an Excell database of names to be used in Outlook and it asks for defining of ranges . Its a one column. I dont understand. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
| Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
| Named Ranges | Excel Worksheet Functions | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
| lable ranges in Excell | Excel Discussion (Misc queries) | |||
Hybrid Mode
