CODEWITHSUNDEEP
excelvbaoutlookmapigal
Pal S
Pal S

Reputation: 49

Excel VBA to extract Outlook Contact's "Notes" property

I am trying to dump the entire GAL from outlook through an Excel VBA Macro

I tweaked the code from below link to suite my needs in excel: Excel Dump GAL

I am able to extract most of the common fields, however I need help on following:

  1. In outlook when we right click on a contact & select "open outlook properties", we get below window: Contact's Outlook Properties In this window there is a "Notes" field which I want to extract for the user. Can someone suggest how to get that
  2. Any Birthday field of the user?

NOTE: I CANNOT install outlookspy due to corporate security policy.

Upvotes: 1

Views: 1058

Answers (1)

Dmitry Streblechenko
Dmitry Streblechenko

Reputation: 66215

The Notes edit box at that screenshot is bound to the PR_COMMENT_W property (DASL name http://schemas.microsoft.com/mapi/proptag/0x3004001F). It should be accessing through the AddressEntry.PropertyAccessor.GetProperty method. ExchangeUser.Notes should also work fine.

Upvotes: 1

Related Questions