Your sheet has some headers across row1 like Name, Address, City, State, Zip,
Telephone, Email with each contact on a row below those headers.

You select the entire range of data first in Excel

InsertNameDefine type in a name like MyName which defines the range you
selected.

Save then boop off to Outlook and FileImport/Export


Gord

On Tue, 27 Nov 2007 22:48:29 -0800 (PST),
wrote:

On Nov 7, 12:52 pm, Gord Dibben <gorddibbATshawDOTca wrote:
With Outlook open go to FileImport ExportImport from another program or file"

Follow your nose from there to choose your Excel workbook.

Thanks Gord
I found the insert-name-define, but it rejected the name I put in,
perhaps 'defined name' is something specific.
really appreciate your help,
Leanne

I would first save the workbook after giving your 3000 member list a defined
name through InsertNameDefine.

Outlook likes that.

Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 15:46:02 -0800, Leanne
wrote:

I am putting a 3,000 list together, and it will have email addresses as well
as postal. Is there a way I can export the list - or format it - so that it
doesnt have to be re-typed for Outlook?