A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

trying to import from excel to contacts



 
 
Thread Tools Display Modes
  #21  
Old January 14th, 2008, 05:18 AM posted to microsoft.public.outlook.contacts
KRGERACI
external usenet poster
 
Posts: 5
Default trying to import from excel to contacts

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




  #22  
Old January 14th, 2008, 06:47 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

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






  #23  
Old January 14th, 2008, 03:15 PM posted to microsoft.public.outlook.contacts
KRGERACI
external usenet poster
 
Posts: 5
Default trying to import from excel to contacts

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






  #24  
Old January 14th, 2008, 05:20 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

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








  #25  
Old January 14th, 2008, 05:32 PM posted to microsoft.public.outlook.contacts
KRGERACI
external usenet poster
 
Posts: 5
Default trying to import from excel to contacts

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









  #26  
Old January 14th, 2008, 07:27 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

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











  #27  
Old January 18th, 2008, 11:22 PM posted to microsoft.public.outlook.contacts
k2c
external usenet poster
 
Posts: 3
Default trying to import from excel to contacts

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.


"Karl Timmermans" wrote:

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












  #28  
Old May 10th, 2008, 04:22 AM posted to microsoft.public.outlook.contacts
jackie
external usenet poster
 
Posts: 216
Default trying to import from excel to contacts

Thank you. Thank you. Thank you.

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

Again, THANK YOU!

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






  #29  
Old June 6th, 2009, 06:15 PM posted to microsoft.public.outlook.contacts
Jes
external usenet poster
 
Posts: 27
Default trying to import from excel to contacts

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?

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

  #30  
Old June 8th, 2009, 01:26 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default trying to import from excel to contacts

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

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


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

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Contacts Do Not display from Fax Wizard DaveoSac Contacts 5 October 4th, 2004 09:46 PM
excel import Filemaker 4 and Mac OS9 Mitsunari New Users 0 August 8th, 2004 07:42 PM
Outlook2000 won't import CSV contacts Greg General Discussions 1 June 21st, 2004 11:59 PM
Help! Tried to import contacts into Outlook 2000.... Emily Contacts 4 May 27th, 2004 02:25 AM
Excel Import Problem Russ Worksheet Functions 1 April 8th, 2004 06:15 PM


All times are GMT +1. The time now is 02:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.