Saving email addresses from excel document

[Don Barley]

I have an excel document with a great number of email addresses which I want
to have put into my address book. I don't want to have to type them over.
Is there a way to select and send them to the address book?

 

[Gord Dibben]

With your Contacts info in columns in Excel..................

Name.........Address..........email.........whatever

Save the workbook after giving your list a defined
name through Insert>Name>Define.

Outlook likes that or make sure the sheet is first in the workbook.

With Outlook open go to File>Import Export>"Import from another program or
file"

Follow your nose from there to choose your Excel workbook.

Note: the mapping can be done while importing.

To see the full list of fields Outlook has, export some of your your
contacts to a new Excel workbook to get an idea of what's available for
mapping.


Gord Dibben MS Excel MVP

On Thu, 24 Jul 2008 16:47:13 -0700, Don Barley <Don