I have an Purchase order template that has a userform.

We also have a Public Folders contact list in my outlook
which everyone has made a favorite of for synchronizin,
containing Vendor information including company name,
address, City, Prov., Postal Code, Full Name, Business
Phone, Business Fax and a Vendor code in Other Phone.

On the user form I would like, somehow, to let the users
access their Favorite folder in Public folder to have
access to this information to pick a vendor and it places
the Number and all the info above into Sheet one in
specified cells.

Is this possible?

I have got it working through comboboxes and vlookups but
seems a duplication of information when it is already in
one central location that everyone can access.

I am a rank beginner as some of you know through helping
me in the combobox/vloopup development. Thanks for your
patience.

Shauna