Outlook and Excel Integration

  • Thread starter Thread starter Shauna Koppang
  • Start date Start date
S

Shauna Koppang

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
 
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.
 
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
 
Back
Top