(Excel) Get Contents of a T-Mobile Text Message (as Email)

How to get the contents of an email that originated as a T-Mobile SMS text.

Download Excel Class Modules Chilkat Excel Class Modules

' First, for the purpose of understanding the structure of the MIME,
' let's load the MIME into a Chilkat MIME object and examine the MIME structure.
Dim mime As Chilkat.Mime
Set mime = Chilkat.NewMime


success = mime.LoadMimeFile("qa_data/eml/TMobileTextMsg.eml")
' Show the MIME structure in text format (as opposed to XML format).
Debug.Print mime.GetStructure("text")

' The MIME structure for our test email looks like this:
' multipart/related
'     text/html
'     text/plain
'     image/gif
'     image/gif
'     image/gif

' The HTML part is not considered a "related item" because the related items
' are defined as being related to the HTML part.  Therefore, we should always
' expect to find a text/html part under a multipart/related.  The HTML parts
' is simply the HTML body, and the other parts are the related items.
' If the text/plain part was to be considered as an alternative body,
' then a properly structured email would include a multipart/alternative structure.

Dim email As Chilkat.Email
Set email = Chilkat.NewEmail

success = email.LoadEml("qa_data/eml/TMobileTextMsg.eml")

' We should see 4 related items.
Debug.Print "Num Related Items = "; email.NumRelatedItems
' There should be 0 attachments.  
Debug.Print "Num Attachments = "; email.NumAttachments

' Find the indices of the text/plain related part, and the text/html related part

i = 0

numRelatedItems = email.NumRelatedItems
Dim sbContentType As Chilkat.StringBuilder
Set sbContentType = Chilkat.NewStringBuilder
Do While i < numRelatedItems
    Dim success As Boolean
    success = sbContentType.Append(email.GetRelatedContentType(i))
    Debug.Print i; ": "; sbContentType.GetAsString()
    If (sbContentType.ContentsEqual("text/plain",False)) Then
        Debug.Print "---- text/plain part:"
        Debug.Print email.GetRelatedString(i,"utf-8")
    End If

    sbContentType.Clear 
    i = i + 1
Loop