I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

Make sure that the checkbox beside the folder you want to import to is
checked - else the "Map Custom Fields" button will not activate.

Just in case this also applies - the term "Map Custom Fields" does not mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the standard
contact form via Outlook's import/export process.

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
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1
to
J12) and while that block is selected, type a name for the range in the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

I don't think we are on the same page.
I am trying to Import an Excel file into Contacts, so the importing of a
Folder does not come into play....??...

thanks

jp

--
Janice P


"Karl Timmermans" wrote:

Make sure that the checkbox beside the folder you want to import to is
checked - else the "Map Custom Fields" button will not activate.

Just in case this also applies - the term "Map Custom Fields" does not mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the standard
contact form via Outlook's import/export process.

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
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1
to
J12) and while that block is selected, type a name for the range in the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

--
Janice P
your Just in case, I think I might be heading towards what you mention
as a custom form, re my previous response... I guess I don't know what the
Standard Fields are, and will that help here?

thanks

Jp


Just in case this also applies - the term "Map Custom Fields" does not mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the standard
contact form via Outlook's import/export process.

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
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1
to
J12) and while that block is selected, type a name for the range in the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

We're very much on the "same page" - follow your import process to the point
where you are encountering the original problem you are asking about.....

#1 - On the "Import A File" screen where the "Map Custom Fields" button
appears - on the left hand portion of that screen you have a listbox under
the title of "The following actions will be performed" where at least one
entry will appear with a checkbox. It is that item that needs to be checked
as per original message in order for the "Map Custom Fields" to activate.

#2 - Contacts does refer to a "folder" which is what you want to import
"into"

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
...
I don't think we are on the same page.
I am trying to Import an Excel file into Contacts, so the importing of a
Folder does not come into play....??...

thanks

jp

--
Janice P


"Karl Timmermans" wrote:

Make sure that the checkbox beside the folder you want to import to is
checked - else the "Map Custom Fields" button will not activate.

Just in case this also applies - the term "Map Custom Fields" does not
mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the
standard
contact form via Outlook's import/export process.

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
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields
button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from
A1
to
J12) and while that block is selected, type a name for the range in
the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges.
Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

Will keep this simple. If you see all the fields listed that you want to
import to then what I wrote "will not apply" and as such can be ignored.

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
...

--
Janice P
your Just in case, I think I might be heading towards what you mention
as a custom form, re my previous response... I guess I don't know what the
Standard Fields are, and will that help here?

thanks

Jp


Just in case this also applies - the term "Map Custom Fields" does not
mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the
standard
contact form via Outlook's import/export process.

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
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields
button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from
A1
to
J12) and while that block is selected, type a name for the range in
the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges.
Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

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.
I can choose "File to import: and browse for it.
and underneath the Options are
* Replace duplicates.
* Allow duplicates
* Do not allow duplicates.

So I have selected the File to import
I click next.

I select the destination Folder, being Contacts, Click Next,
and I get my error message.

"An error has occurred in the Microsoft Excel translator while getting the
contents of a file system. .....file name has no named ranges, Use Excel to
name the range of data you want to import."

I did name the ranges, so I think I haven't given the correct range names?






--
Janice P


"Karl Timmermans" wrote:

We're very much on the "same page" - follow your import process to the point
where you are encountering the original problem you are asking about.....

#1 - On the "Import A File" screen where the "Map Custom Fields" button
appears - on the left hand portion of that screen you have a listbox under
the title of "The following actions will be performed" where at least one
entry will appear with a checkbox. It is that item that needs to be checked
as per original message in order for the "Map Custom Fields" to activate.

#2 - Contacts does refer to a "folder" which is what you want to import
"into"

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
...
I don't think we are on the same page.
I am trying to Import an Excel file into Contacts, so the importing of a
Folder does not come into play....??...

thanks

jp

--
Janice P


"Karl Timmermans" wrote:

Make sure that the checkbox beside the folder you want to import to is
checked - else the "Map Custom Fields" button will not activate.

Just in case this also applies - the term "Map Custom Fields" does not
mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the
standard
contact form via Outlook's import/export process.

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
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields
button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from
A1
to
J12) and while that block is selected, type a name for the range in
the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges.
Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???

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]

I thought I had, but checked and the Naming had not stuck....spent some more
time on it and am now making progress.
I think I'm almost there.
Thanks for all your help.


--
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]

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]