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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
[email protected] said:
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
Click to expand...


<sigh> you HAVE looked at Import/Export function in 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.
 
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.
 
..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?
 
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
 
Back
Top