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



"KRGERACI" wrote in message
...
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" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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.

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