Lookup Outlook Contact to Fill Excell Cells

[Guest]

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

 

[Guest]

Well creating the list box was not to bad but now I am trying to find out how
to pass some arguments to the form. I want to re-use the Form module to write
the found address values to a series of Cells (not necessarily in the same
relation each time) based on calling the form from a command button. the
Specific cells to write to are contingent on which command button I use to
call the form.

my only thought at the moment is to creat a hidden(? will that work?)
worksheet to hold the information in fixed cells.

I have tried Static Variables & procedures but i guess the class modules &
form modules are in separate spaces.

any help?