Export names and address into outlook
 

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?

Export names and address into outlook
 

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?

Export names and address into outlook
 

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?

Export names and address into outlook
 

By headers I mean you have at least 2 columns with titles like Name Address
and the data in rows below these.

Select the title cells and those below with the data.

Assume A1:B4 looks like this.............

Name Address
Gord 123 main st.
Toby 456 second sr.
Bert 789 third st.

Select A1:B4 and InsertNameDefine.

BTW........nothing is done in the fx box........fx is the Function Wizard


Gord

On Wed, 21 Nov 2007 15:13:01 -0800, Toby wrote:

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?