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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"redletters2" wrote in message ...
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