trying to import from excel to contacts

[Guest]

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

 

[Jocelyn Fiorello [MVP - Outlook]]

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

 

[Guest]

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

 

[Guest]

I have the same problem but don't understand the instructions. I have names
in cells A2 through A23 and e-mail addresses in B2:B23 in A1, I have Name. in
B1, E-mail. I tried high lighting A2:B23, then in the box, type any name
and also tried typing A2:B23 in that box. Neither works. What is the
procedure?

 

[Guest]

M. Fiorello have good clue thanks you, it's working good i am now able to
import easily file from excel ... BUT the phone number imported in outlook
are not the right number it seem that there is a format problem. Somebody
know how to coorect that?

 

[Guest]

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

 

[Guest]

Jocelyn -

Thanks - worked like a charm!!!

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

 

[Guest]

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

 

[Karl Timmermans]

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

 

[Guest]

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

 

[Guest]

--
Janice P
Re: 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

 

[Karl Timmermans]

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

 

[Karl Timmermans]

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

 

[Guest]

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?

 

[Brian Tillman]

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.

 

[Guest]

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.

 

[Guest]

Brian: Sorry to keep bugging you.
Re: 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 re: above, to reference my column of
combined names, or if that is possible.

 

[Karl Timmermans]

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

 

[Guest]

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

 

[Brian Tillman]

Brian: Sorry to keep bugging you.
Re: 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.