Outlook and Excel Integration
 

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

Outlook and Excel Integration
 

Hi Dick,

Will be working on it today so I may have more questions.
Thanks for the link and the information. Will post
replies here as I come across questions.

Shauna
-----Original Message-----
Shauna

I'm sure that it's possible. Start here

http://www.dicks-clicks.com/excel/olContacts.htm

I think the Public Folder is unique to Exchange, which I
don't have so I
can't give you more specific information. I think you
just need to figure
out how to get to the that MAPIFolder (the Public Folder)
and then cycle
through all the objects (ContactItems?) in it. You can
then add those
objects to a combobox so the user can select the one they
want.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

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



.