(Excel) Get the Email Received Date/Time

Get's the date/time from the topmost Received header. The date/time of when you received an email may be different than the date/time stored in the Date header field, which if truthful, is the date when the email was sent.

The Received header field will look something like this:

Received: from mail.example.com (mail.example.com [99.255.255.99])
 by inbound-smtp.us-west-2.amazonaws.com with SMTP id 72ma443vs1g0o6vqd8erojkpss35s0dt32h323o1
 for admin@chilkatsoft.com;
 Wed, 25 Jul 2018 08:04:23 +0000 (UTC)

Download Excel Class Modules Chilkat Excel Class Modules

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


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

Dim sb As Chilkat.StringBuilder
Set sb = Chilkat.NewStringBuilder
success = sb.Append(email.GetHeaderField("Received"))

'  Replace semicolons with CRLF's

numReplaced = sb.Replace(";",vbCrLf)

Dim st As Chilkat.StringTable
Set st = Chilkat.NewStringTable
success = st.AppendFromSb(sb)

If (st.Count = 0) Then
    Debug.Print "Should have at least one line.."
    Exit Sub
End If

'  The date/time string is the last line in the string table.
success = sb.SetString(st.StringAt(st.Count - 1))
success = sb.Trim()

Debug.Print "Received date/time = "; sb.GetAsString()