Recepient properties (such as department)

[waxwing]

Hi, I created a small VBA app in Excel that retrieves a list of meeting
attendees and their response status. These attendees are always
employees and I'm able to resolve the names as I retrieve them. Along
with response status I'd like to pull some Outlook Properties such as
department and phone number. I'm not sure where to find that
information. Are those properties of the recepient? How can I get at
them?

Thanks.

- John

 

[Ken Slovak - [MVP - Outlook]]

Some things are exposed in the AddressEntry property of the Recipient
object. Other than those properties you'd have to access the AddressEntry
using an API such as CDO 1.21 or Extended MAPI or Redemption to get at the
fields collection of the AddressEntry object.

Look in the Object Browser to see what's available, everything else that's
in Details you'd have to bypass the Outlook object model for.

 

[waxwing]

Thanks, Ken. I never used the object browser before. Wish I had. It
looks like I'll need to use one of the suggested APIs since the fields
I need are not available with AddressEntry. I have no experience with
CDO, Extended MAPI or Redemption so I guess that means I'll learn
something new. Time to go check those approaches out.

- John

 

[Ken Slovak - [MVP - Outlook]]

I use Redemption myself, FWIW.

For Redemption examples and information: www.dimastr.com/redemption

For tons of CDO 1.21 information: www.cdolive.com/cdo5.htm and
www.cdolive.com/cdo10.htm

That first link for CDO has some samples that Siggi put up for getting
properties from an AddressEntry and the second one lists various property
tags, many undocumented that Siggi reverse engineered, including
AddressEntry property tags.

Extended MAPI requires programming in C++ or Delphi.