How can I import contact info from Excel or Word into Outlook

[Guest]

I have a relatively large number of contacts that I want to upload into
Outlook Contacts. How do I do it? They are currently in Excel. Names,
addresses, email contacts etc. Omar

 

[Gordon]

I have a relatively large number of contacts that I want to upload into
Outlook Contacts. How do I do it? They are currently in Excel. Names,
addresses, email contacts etc. Omar

<sigh> you HAVE looked at Import/Export function in Outlook?

 

[Sue Mosher [MVP-Outlook]]

Apply a name to a single range covering all the data in Excel, save as an .xls file, then use File | Import and Export in Outlook.

 

[Guest]

Yes. As a matter of fact, I finally tried using the Import, then worked my
way to the Comma Seperated Values (Windows) and got 96 items uploaded. I
only got the name and emaill address uploaded so now I need to figure out how
to get the rest of the contact information uploaded. thanks for your
response.

 

[Guest]

..xls? Do I have to save the Excel file as .xls or should I use Coma
Seperated Values (Windows) or does it make a difference?

 

[Sue Mosher [MVP-Outlook]]

You can use either, but if you use an .xls file, you must take care that the named range covers all the data, all the columns and rows.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54