How do I setup an excel file to import into outlook contacts

[redletters2]

I have large address books in excel and I want to import them to outlook, but
I am not sure how to go about formating the excel document so that i can
import them into outlook

 

[Sue Mosher [MVP-Outlook]]

Each address entry needs to be on its own row. Use the Insert | Name command to create a named range that includes all the data and a row of column headings with the field names. Save the file.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers