Either give the range a name or make sure the sheet with the data is first sheet
in line.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 13:54:01 -0700, Christine
wrote:

I have never had a problem importing excel files into Outlook. The original
source is Access. Today, I keep getting the same error message and I do not
know why it is doing it now or how to solve the problem. The Error message
is:

File name has no name ranges. Use Microsoft Excel 97-2003 to name the range of data you want to import.

I have never had to do this before in exporting from excel to Outlook
contacts. I would like to have it so I do not have to do this everytime I
import from excel. any words of wisdom would be greatly appreciated.

Christine