(Excel) Forward an Email using CreateForward

Reads an email from an IMAP server, creates a forward version of the email using the CreateForward method, and sends the email to another recipient.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' Read the 1st (most recent) email in an Inbox.
Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

' Connect to an IMAP server.
imap.Ssl = True
imap.Port = 993

success = imap.Connect("imap.someMailServer.com")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Login
success = imap.Login("myLogin","myPassword")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Select an IMAP mailbox
success = imap.SelectMailbox("Inbox")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If


numEmails = imap.NumMessages

' Fetch the email at the last sequence number.
' (We are assuming the Inbox has at least 1 email)

Set email = imap.FetchSingle(numEmails,False)
If (imap.LastMethodSuccess = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Disconnect from the IMAP server.
Dim success As Boolean
success = imap.Disconnect()

Debug.Print email.Subject


Set eForward = email.CreateForward()

' The eForward email has no To or CC recipients yet.
' Add one or more..
success = eForward.AddTo("Chilkat Support","support@chilkatsoft.com")

' We also need to specify the From name/address.
eForward.FromAddress = "matt@someMailServer.com"
eForward.FromName = "Matt"

' If we wish to add text at the start of the email body:
Dim sbHtmlBody As Chilkat.StringBuilder
Set sbHtmlBody = Chilkat.NewStringBuilder
If (eForward.HasHtmlBody() = True) Then
    success = sbHtmlBody.Append(eForward.GetHtmlBody())
    success = sbHtmlBody.Prepend("<p>Hello, this is an email I'm forwarding to you...</p>")
    eForward.SetHtmlBody sbHtmlBody.GetAsString()
End If

Dim sbPtBody As Chilkat.StringBuilder
Set sbPtBody = Chilkat.NewStringBuilder
If (eForward.HasPlainTextBody() = True) Then
    success = sbPtBody.Append(eForward.GetPlainTextBody())
    success = sbPtBody.Prepend("Hello, this is an email I'm forwarding to you..." & vbCrLf & vbCrLf)
    eForward.SetTextBody sbPtBody.GetAsString(),"text/plain"
End If

' We could save the .eml, then double-click on it to view in our mail program, such as Outlook or Thunderbird..
success = eForward.SaveEml("qa_output/forward.eml")

' We could send (forward) the email..
Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

mailman.SmtpHost = "smtp.someMailServer.com"
mailman.SmtpUsername = "myLogin"
mailman.SmtpPassword = "myPassword"
mailman.SmtpPort = 587
mailman.StartTLS = True

success = mailman.SendEmail(eForward)
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

success = mailman.CloseSmtpConnection()
If (success <> True) Then
    Debug.Print "Connection to SMTP server not closed cleanly."
End If

Debug.Print "Mail Sent!"