none
[E2003][PS] extracting proprietary meta data from a message RRS feed

  • Question

  • We are running an application (Symantec Enterprise Vault) that modifies messages in the Exchange messaging store in order to store some application-specific information there. We have a need to extract this information.

    I have been able to use outlook.application from a powershell script to browse through mailbox folders for messages and display numerous properties, including the body (as text and as html), addressing fields, date fields... virtually all of the properties that outlook and exchange use in processing email.

    The data we are looking for does not seem to be contained in any of the properties exposed by outlook.application that I am aware of, but we can find it if we save one of the messages in a .msg file. It occurs to me that the information could be embedded in script, as the application requires outlook to be configured to allow scripts to run in any folder.

    If anyone knows how to use outlook.application to extract either the full binary equivalent of the entire message (as one can do by saving a message as a .msg file), to extract any third-party meta data chunks, or where embedded script is stored, I would be most appreciative.

     I initiallly posted about this problem here: http://social.technet.microsoft.com/Forums/en-US/exchangesvrclients/thread/2cd4ca18-bf5c-4701-8033-a171547ae730, and was referred to this forum. Given the focus here I was wondering if it would be possible to extract this information directly from the message store rather than indirectly through the client.

    Alternately, maybe someone here knows of a completely different way to do what we are trying to do.

    Sunday, February 5, 2012 6:39 AM

All replies

  • >I have been able to use outlook.application from a powershell script to browse through mailbox folders for messages and display numerous properties, including the body (as text and as html), addressing fields, date fields... virtually all of the properties that outlook and exchange use in processing email.

    Most probably that data your after is stored in a custom Extended Mapi Property (or a number of them) to access the underlying Mapi properties of a message you need to use a Mapi editor http://mfcmapi.codeplex.com/ to firstly examine a message where you will be able to see all the properties that have been set on that message. Once you work out which property (or properties) your after you can then access them from your code eg in Outlook OOM you can use the propertyAccessor http://msdn.microsoft.com/en-us/library/bb176395(v=office.12).aspx

    Cheers
    Glen
    Monday, February 6, 2012 4:47 AM
  • >I have been able to use outlook.application from a powershell script to browse through mailbox folders for messages and display numerous properties, including the body (as text and as html), addressing fields, date fields... virtually all of the properties that outlook and exchange use in processing email.

    Most probably that data your after is stored in a custom Extended Mapi Property (or a number of them) to access the underlying Mapi properties of a message you need to use a Mapi editor http://mfcmapi.codeplex.com/ to firstly examine a message where you will be able to see all the properties that have been set on that message. Once you work out which property (or properties) your after you can then access them from your code eg in Outlook OOM you can use the propertyAccessor http://msdn.microsoft.com/en-us/library/bb176395(v=office.12).aspx

    Cheers
    Glen

    Thanks, I'll give your suggestion a try.
    Monday, February 6, 2012 5:21 PM