Excel-Outlook Contact List

[links_now]

Is there a way to take a list of names, phone numbers and e-mail from a Excel
spreadsheet and export or put them into to your outlook cantact list?

 

[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.

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