(Excel) Set the Email Date Header to the Current System Date/Time

Demonstrates how to set the Date header field of an email to the computer's current date/time. Note: When an email object is instantiated, the Date header field is automatically added and initialized to the current system date/time. The need to explicitly set the Date header could arise when loading an email from a .eml.

Download Excel Class Modules Chilkat Excel Class Modules

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

' At this point, a new email object has been instantiated, and it
' already has a Date header field containing the current date/time.
Debug.Print "Date: "; email.EmailDateStr

' We can also get the Date header like this:
Debug.Print "Date: "; email.GetHeaderField("Date")

' Load a .eml into the email object:

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

' Show the Date that was in the .eml
Debug.Print "Date: "; email.EmailDateStr

' Now the Date header contains whatever was in the .eml
' Let's update it to the current system date/time..

Dim dateTime As Chilkat.CkDateTime
Set dateTime = Chilkat.NewCkDateTime

Dim success As Boolean
success = dateTime.SetFromCurrentSystemTime()

success = email.SetDt(dateTime)
If (success <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' Now show that the Date is the current system time:
Debug.Print "Date: "; email.EmailDateStr
Debug.Print "Date: "; email.GetHeaderField("Date")