trying to import from excel to contacts

[KRGERACI]

Jocelyn: Did exactly as you suggest, no avail? I have imported dozens of
Excel spreadsheets into Microsoft Outlook in the past with no problem, but no
matter what I do I continue to get the same error message as okii? Can't
understand it, wasted 3 hours today trying to figure it out!!! VERY
frustrating, what do you suggest, keep getting the same stupid error message,
that my Excel spreadsheet on contacts has "no named range" ????? It goes on
to say Use Microsoft Excel 97-2003 to name th range of the data you want to
export."

Microsoft programmers are such geniuses! If I upgraded to 2007, how can I
make the changes in 97-2003. This 2007 Upgrade is truly the most retarded
upgrade to date. This is one of the many problems I have had which were
NEVER problems before in the older version.

Anyone have an answer to this current issue, the one stated here does not
work.

 

[Karl Timmermans]

Solution to your problem (there are 2)

Option #1

a) create your named ranges as req'd in Excel '2007
b) save your worksheet as a "Excel 97-2003 Workbook" - use <SAVE AS> (.xls
file extension) and NOT as "Excel Workbook" (.xlsx file extension)
c) import newly saved workbook

Option #2

a) Just save your worksheet as a CSV file - import that and not worry about
any of the above

Office '2007 file formats for Access or Excel are NOT supported by Outlook
'2007 import/export but ARE supported by Outlook '2007 with Business Contact
Manager import/export. Why? Hmmmm.....maybe because someone simply
overlooked including updating the standard Outlook import/export wizards
which haven't been touched in years?

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

 

[KRGERACI]

Karl: Thanks, I did as you suggested, and now I get throught the mapping OK
(thought I was home free!) and now Outlook shuts down with the dreaded
"problem with Outlook, we have to shut it down" and that has happened
regardless of what Excel spreadsheet I use? Business Contact Manager is
extra, of course! Anywhere I can get these filters for less or do I have
another problem?

Thanks!

 

[Karl Timmermans]

Is this occurring whether you map a CSV file or XLS file? If only for XLS -
would try CSV but at the same time take a close look at your header row and
make sure that there is nothing strange in any of the cell names which
appears to be triggering the problem from your description.

While others may have other/better suggestions - here are the ones that come
to mind

#1 - Run an "Office Diag" within Outlook to resolve any potential issues
#2 - If above doesn't work - then do a full repair re-install (logically
this should be the same as above but.....)

Sundry comments

#1 - Would never get BCM just for the sake of the import/export wizards if
you have no need for the BCM contact construct - 2 different animals
#2 - Filters are only available on appropriate Office setup disk and there
are no filters available that I know of for '2007 file formats other than
with BCM
#3 - Alternatives would be 3rd party import/export products (which is where
we come in but, in general, doesn't sound like you fit the profile for a
typical CG customer given your requirements (assuming you're just importing
standard fields in which case the CSV file format will always be your safest
bet). You are however, welcome to try any of our entry level CG Importer
product just to see if the problem(s) disappear because if not, then there
are larger issues at play - http://www.contactgenie.com/cg20features.htm


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

 

[KRGERACI]

Purchased your Contact Genie product this AM- "A Miracle Product", all my
issues evaporated OUTSTANDING! Thanks.

Can't believe I wasted 4 hours yesterday and imported 2500 contacts in 15
minutes this AM!

Thanks again!

 

[Karl Timmermans]

Glad it worked out - guess will have to expand the definition of a "typical
CG customer" .

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

 

[k2c]

I was also having the "no named range" problem while I was trying to import
contacts from Excel file. I search thru the post and tried a number of ways
to define the name range. Then I got an ODBC error stating 'too many fields
defined'. It turns out that during my trial/error process of defining the
name range, I created a number of them and need to delete the obsolete ones.
To do so, perform the following in Excel:

1. Insert | Name | Define
2. If you defined more than one name, a list of names should be displayed
3. Highlight the one(s) you don't want and click the [delete] box

Once there's only one named range, you can follow the Import method
suggested in a number of post and eventually should be able to see the screen
with the "Map Custom Fields" box.

Hope this supplement helps. I spent a number of hours in figuring out that
my problem was having multiple named ranges after the more common 'no named
range' error was resolved.

 

[JACKIE]

Thank you. Thank you. Thank you.

Export to from .xls to .csv (MS DOS) and save yourself a lot of pain.

Again, THANK YOU!

 

[jes]

I created a name range and now my document is not available to open.

How do I get the document opened and download the contacts into Outlook?

 

[Diane Poremsky [MVP]]

Did you close the file in excel before trying to open in outlook?

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.