I have a excel spreedsheet with all my outlook contacts, I want to update my
address book. I can't seem to find a quick way to export the data from excel
to outlook.. can anyone help? Many thanks,

Have you tried Contacts: File: Import/Export: Import from another program:
Excel?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Carla" wrote:

I have a excel spreedsheet with all my outlook contacts, I want to update my
address book. I can't seem to find a quick way to export the data from excel
to outlook.. can anyone help? Many thanks,

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

Name.........Address..........email.........whatev er

Save the workbook after giving your list a defined
name through InsertNameDefine.

Outlook likes that.

With Outlook open go to FileImport 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 Mon, 21 Jul 2008 17:06:00 -0700, Carla
wrote:

I have a excel spreedsheet with all my outlook contacts, I want to update my
address book. I can't seem to find a quick way to export the data from excel
to outlook.. can anyone help? Many thanks,