Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / October 2005

Tip: Looking for answers? Try searching our database.

How do i import multiple address from an excel sheet to outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DR-MDC - 01 Oct 2005 14:45 GMT
I can't get outlook to import more than one line (ie one contact) from an
excel spreadsheet.  How do I get it to import the other 82 lines/contacts??
Terry - 24 Oct 2005 08:01 GMT
1)...What you want to do is first make sure the names of the columns in your
spreadsheet jive with the names of the fields used by outlook when you write
emails. You can add a fake contact in Outlook, or view a current contact in
Outlook, to see what the important fields are named (for example, First,
Middle, Last, Nickname, Phone, Fax, Email Address).

2)...If all is well, in Excel, export the spreadsheet to a text file (comma
seperated), and save to hard disk or floppy.

3)...In Outlook, click the "File" menu, hover over "Import", click "other
address book", click "Text File (Comma Seperated Values)", browse to the .csv
file and double-click it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.