A very simple alternative to dealing with Named Ranges in Excel for purposes
of importing in Outlook is to simply save your worksheet as a .CSV file and
import that file instead, avoiding Named Ranges entirely. Aside from that -
you assign ONE name to all the columns/rows that you want to import in
Outlook - not one name per column.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com




"worker bee" wrote in message
...
Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.
I suspect that this may be a problem as this column is a formula combining
two other columns. (first & last names) into one.
I have not been able to get a good understanding of how the steps in the
Insert Menu's, Name... Define, Paste, Create, Apply, & Label are to be
handled or executed....or made to work above, to reference my column
of
combined names, or if that is possible.
--
Janice P


"Brian Tillman" wrote:

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.

Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]

Okay! Thankyou!...csv, finally got it to work.
Man, was that a trip around the block.
Thanks for this.
--
Janice P


"Karl Timmermans" wrote:

A very simple alternative to dealing with Named Ranges in Excel for purposes
of importing in Outlook is to simply save your worksheet as a .CSV file and
import that file instead, avoiding Named Ranges entirely. Aside from that -
you assign ONE name to all the columns/rows that you want to import in
Outlook - not one name per column.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com




"worker bee" wrote in message
...
Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.
I suspect that this may be a problem as this column is a formula combining
two other columns. (first & last names) into one.
I have not been able to get a good understanding of how the steps in the
Insert Menu's, Name... Define, Paste, Create, Apply, & Label are to be
handled or executed....or made to work above, to reference my column
of
combined names, or if that is possible.
--
Janice P


"Brian Tillman" wrote:

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.

Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]

worker bee wrote:

Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.

You want to have one named range. I don't know why you are naming each
column. Highlight the entire section of data and then give the selection a
single name.
--
Brian Tillman [MVP-Outlook]