How many times of you seen someone ask (or have even asked yourself) – Why are there so blank rows when I import my Excel file into Outlook (or even a CSV file created via Excel)?

There are many things you don’t have to think about when working strictly within the confines of a one program. However, when the data contained in one program has to be used in another program, the integrity of the data becomes important.

Importing from an Excel file is very common activity. There is likely a good chance that if you are reading this that you are currently investigating a problem that you are having or have had one in the past. One Excel feature that probably generates the most questions (and problems) is “Named Ranges” which include the following:

• When I try to import it keeps asking me for a “named range”