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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |