none
Vba Conversation Index property RRS feed

  • Question

  • Hi,

    When I retrieve the conversation index property via a standard mailItem.ConversationIndex method I get a string representation of that value, e.g 0101E0E9771924156A66026A4A5ED39016CB76795FA7.

    However, when I use the columns.add method of the table object to add 

    Const CONVERSATION_INDEX = "http://schemas.microsoft.com/mapi/proptag/0x00710102"

    via olTable.Columns.Add (CONVERSATION_INDEX) and then when I get the values via Val = olRow.GetValues

    val(5) which should be the conv index returns 21 numeric values (??)

    Why does that happen and how can I compare those two values to see if they match?

    Thanks
    Tuesday, January 28, 2014 10:04 PM

Answers

  • You would need to loop through the returned array (LBound and UBound) and convert each element to a hex string using the Hex function.

    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.5 is now available!

    • Marked as answer by Bednar87 Tuesday, January 28, 2014 10:34 PM
    Tuesday, January 28, 2014 10:26 PM

All replies

  • This is a binary property, and you will get a variant array of byte.


    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.5 is now available!

    Tuesday, January 28, 2014 10:13 PM
  • Thank you, Dmitry.

    I am a VBA Outlook newb so I might be asking stupid questions, but is there a way to compare those. I'd be OK with writing a custom function, but first I'd need to know if there is a way to compare those two -  make the array translate into a string or by some other method.

    Thanks :-)

    Tuesday, January 28, 2014 10:18 PM
  • You would need to loop through the returned array (LBound and UBound) and convert each element to a hex string using the Hex function.

    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.5 is now available!

    • Marked as answer by Bednar87 Tuesday, January 28, 2014 10:34 PM
    Tuesday, January 28, 2014 10:26 PM
  • Worked like a charm. Many many thanks!
    Tuesday, January 28, 2014 10:34 PM