(Excel) Email Body - Plain Text and/or HTML

Any given email may have a plain-text body, an HTML body, or both. The Body property will return the HTML body by default (if it exists) otherwise it will return the plain-text body. There are methods for checking to see if an email has a particular body (HasPlainTextBody and HasHtmlBody) and there are methods for getting a specific body: GetHtmlBody, GetPlainTextBody.

Download Excel Class Modules Chilkat Excel Class Modules

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

'  Load an email from a .eml

success = email.LoadEml("something.eml")
If (success <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

'  Display the default Body:
Debug.Print email.Body

'  If a plain-text body is present, display it:

bText = email.HasPlainTextBody()
If (bText = True) Then
    Debug.Print email.GetPlainTextBody()
End If

'  If an HTML body is present, display the HTML source:

bHtml = email.HasHtmlBody()
If (bHtml = True) Then
    Debug.Print email.GetHtmlBody()
End If