In MS Outlook VBA, can I search the properties of an e-mail?

Question

When I load an e-mail by EntryID, I can add a watch on the MailItem object and get a list of all its properties. But I have to click on each one to see their values. Is there a way to search them all for a string I expect to be somewhere in the properties?

Answer 1

No, you need to check each property separately. Under the debugger attached you can view the object properties and find the required one for using in the code.

Answer 2

I found that it is possible to list MailItem properties and their values using the Typelib Information thing mentioned here and also the CallByName function.

First you must select: Tools - References - TypeLib Information

Sub properties_list(ByVal o As Object)
'must add Tools - References - "TypeLib Information"

  Set t = New TLI.TLIApplication
  Set ti = t.InterfaceInfoFromObject(o)
  Dim mi As TLI.MemberInfo
  
  'needed or else will get invalid procedure call or argument for CallByName with some properties
  On Error Resume Next

  For Each mi In ti.Members
    If mi.InvokeKind = INVOKE_PROPERTYGET Then
      Debug.Print mi.Name & " = " & CallByName(o, mi.Name, VbGet)
    End If
  Next

  On Error GoTo 0
End Sub

It will list properties if you run properties_list(MailItem). So you could use this method to search all the property values for strings.