Manually map the fields you want to import (use button when it appears).Import the CSV file instead of the Excel file.Some may disagree with that premise but it comes down to productivity and priorities. You should really be concentrating on getting the task completed and move on. If the sole reason you are dealing with “Named Ranges” is because you are trying to import Excel data into Outlook and especially if it is something that you only do “once in a while”, then it is most likely that you are spending needless time trying to learn something that is otherwise of no value to you. This particular article is not going to cover the “how-to” of named ranges but rather provide a very simple alternative to importing information contained in an Excel worksheet that not only solves the above topics but eliminates a variety of other issues. Added some new contacts (rows) to my Excel spreadsheet but these won’t import.Some columns are not appearing when mapping fields.It’s only importing “x” number of contacts from my Excel file no matter what I do.Ended up with all kinds of blank contacts in the Outlook folder.When I try to import it keeps asking me for a “named range”.If you are reading this then its likely you are or have encountered a problem importing from an Excel worksheet. One Excel feature that probably generates the most questions (and problems) is “Named Ranges” which include the following: The only options with ‘2013 are CSV text and Outlook PST files. UPDATE: Starting with Outlook ‘2013, Excel (.xls) files are no longer supported in either the import or export process.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |