when I select the row with the headings on it....do I rename in the fx box?

"Gord Dibben" wrote:

Yes.

Select the range that has the names and addresses including headers and
InsertName?Define.

Give it a name like MyName

Save then try again.


Gord Dibben MS Excel MVP

On Wed, 21 Nov 2007 14:21:00 -0800, Toby wrote:

I am trying into import from outlook a data base that is in Excel...error
pops up stating that there is "no named ranges" any ideas or suggestions?