 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / May 2008trying to import from excel to contacts
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??? 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.  SignatureJocelyn 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. *** > 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??? > 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 [quoted text clipped - 7 lines] > > > > what does this mean and what do i do??? 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? > 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 [quoted text clipped - 7 lines] > > > > what does this mean and what do i do??? 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? > 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 [quoted text clipped - 7 lines] > > > > what does this mean and what do i do??? 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 [quoted text clipped - 7 lines] > > > > what does this mean and what do i do??? 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 SignatureJanice P > 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 [quoted text clipped - 7 lines] > > > > what does this mean and what do i do??? 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 >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, [quoted text clipped - 20 lines] >> > >> > what does this mean and what do i do??? 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 SignatureJanice P > Make sure that the checkbox beside the folder you want to import to is > checked - else the "Map Custom Fields" button will not activate. [quoted text clipped - 35 lines] > >> > > >> > what does this mean and what do i do??? 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 >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 [quoted text clipped - 49 lines] >> >> > >> >> > what does this mean and what do i do??? 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? SignatureJanice P > 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..... [quoted text clipped - 69 lines] > >> >> > > >> >> > what does this mean and what do i do??? > In Outlook, when I click on: > File Menu: [quoted text clipped - 5 lines] > 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. SignatureBrian Tillman [MVP-Outlook] 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. SignatureJanice P > > In Outlook, when I click on: > > File Menu: [quoted text clipped - 9 lines] > importing? The error you cited indicates you have not and you must. In > Excel, look for "named range" in Help. 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. SignatureJanice P > > In Outlook, when I click on: > > File Menu: [quoted text clipped - 9 lines] > importing? The error you cited indicates you have not and you must. In > Excel, look for "named range" in Help. 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 > Brian: Sorry to keep bugging you. > Re: Range Naming. [quoted text clipped - 21 lines] >> importing? The error you cited indicates you have not and you must. In >> Excel, look for "named range" in Help. Okay! Thankyou!...csv, finally got it to work. Man, was that a trip around the block. Thanks for this. SignatureJanice P > 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 [quoted text clipped - 34 lines] > >> importing? The error you cited indicates you have not and you must. In > >> Excel, look for "named range" in Help. > 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. SignatureBrian Tillman [MVP-Outlook] SignatureJanice 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 > 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 [quoted text clipped - 32 lines] > >> > > >> > what does this mean and what do i do??? 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 >> Just in case this also applies - the term "Map Custom Fields" does not >> mean [quoted text clipped - 38 lines] >> >> > >> >> > what does this mean and what do i do??? 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. > 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 [quoted text clipped - 7 lines] > > > > what does this mean and what do i do??? 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 > 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 [quoted text clipped - 32 lines] >> > >> > what does this mean and what do i do??? 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! > Solution to your problem (there are 2) > [quoted text clipped - 59 lines] > >> > > >> > what does this mean and what do i do??? 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 > Karl: Thanks, I did as you suggested, and now I get throught the mapping > OK [quoted text clipped - 85 lines] >> >> > >> >> > what does this mean and what do i do??? 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! > 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 [quoted text clipped - 119 lines] > >> >> > > >> >> > what does this mean and what do i do??? 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 > Purchased your Contact Genie product this AM- "A Miracle Product", all my > issues evaporated OUTSTANDING! Thanks. [quoted text clipped - 147 lines] >> >> >> > >> >> >> > what does this mean and what do i do??? 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. > Glad it worked out - guess will have to expand the definition of a "typical > CG customer" :-). [quoted text clipped - 157 lines] > >> >> >> > > >> >> >> > what does this mean and what do i do??? Thank you. Thank you. Thank you. Export to from .xls to .csv (MS DOS) and save yourself a lot of pain. Again, THANK YOU! > Solution to your problem (there are 2) > [quoted text clipped - 59 lines] > >> > > >> > what does this mean and what do i do??? > 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???
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.