Excel-Outlook Contact List

L

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?
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top