Search code examples
excelvbaoutlookmapigal

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.

Solution

  • 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.