how do I export excel spreedsheet to outlook address book?
 

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,

how do I export excel spreedsheet to outlook address book?
 

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,

how do I export excel spreedsheet to outlook address book?
 

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,