Lookup Outlook Contact to Fill Excell Cells
 

Using Office Pro 2003 I am trying to create in Excel a macro that will
essentially open the Outlook Contact Lookup combo box and subsequent pop-up
that will allow me to select a contact from my contact list and import the
data into selected Cells on an my excel worksheet. Essentially I am trying
to automate Vendor Information Entry on a Purchase order form and Customer
information Entry on an order form.

I am pretty proficient with VB for applications but can not seem to find the
object/method to call the outlook "Find a Contact" process.

I suppose I could create a macro to iterate through all the fields in all
the address entrys in all address books compare tham to the user entered
search criteria and post the results to a listbox on a pop-up form page which
the user could then pick the item he wanted. but it seems like there should
be a more direct way to do this.

any thoughts would be appreciated

Thanks