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

D

DR-MDC

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

Terry

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.
 

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