Export Excel data to outlook contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nine - 07 Oct 2006 14:59 GMT

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!

Reply to this Message

Gord Dibben - 07 Oct 2006 17:08 GMT

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.
[quoted text clipped - 15 lines]
>Thanks
>for any help!

Gord Dibben MS Excel MVP

Reply to this Message

Rate this thread: