Steven

You can pull Outlook information into Excel through automation. Start here
http://www.dicks-clicks.com/excel/olContacts.htm

If you want to put every company in a data validation drop down, I would
suggest putting the list on a separate sheet and using that list as the
source for you data validation. If yoiu need more help, provide some
specifics about where you data goes and what you want to do with it.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Steven" wrote in message
...

From: "Steven"
Subject: Outlook Address book linked to Excel
Date: Tuesday, May 11, 2004 4:11 PM

I am looking for a way to display contact record information from within
Excel. How can I pull information into a worksheet based on current record
view within outlook. i.e., Company, Contact, Email, Phone, etc...???

Is there a way to do a data validation list to display all records from a
company field and have other named cells update based on the record
selected?