Export Excel data to outlook contacts

N

nine

I would like to know how to export a list of adresses from an Excel
worksheet to Outlook.

The problem seems to be in naming the range of data.

The top row of the worksheet contains colum names like Name, Address,
State...

Row 2 starts the data.

So I have tried both ranges A1:H4903, and A2:H4903 each 1 at a time, and
saved and closed the file.

When trying to import to Outlook it tells me to name the ranges using excel.

What am I missing?

Thanks
for any help!
 
G

Gord Dibben

nine

Select A1:H4903 and Insert>Name>Define.

Give that range a name like MyAddys.

Save the workbook.

Try again.

Alternative.........................

From the Outlook end.

File>Import>Follow your nose from there.

For some assistance.......................

Browse through this google search result for one method of importing the Excel
contacts to Outlook.

http://snipurl.com/pssw


Gord Dibben MS Excel MVP

I would like to know how to export a list of adresses from an Excel
worksheet to Outlook.

The problem seems to be in naming the range of data.

The top row of the worksheet contains colum names like Name, Address,
State...

Row 2 starts the data.

So I have tried both ranges A1:H4903, and A2:H4903 each 1 at a time, and
saved and closed the file.

When trying to import to Outlook it tells me to name the ranges using excel.

What am I missing?

Thanks
for any help!
Click to expand...

Gord Dibben MS Excel MVP
 
Top