(Excel) Forward by Attaching the Existing Email to a New Email

Demonstrates how to forward an email by attaching the email to a new email. This example uses the AttachEmail method, which is new in Chilkat v9.5.0.87.

This example reads an email from an IMAP server, attaches the email to a new email, and sends the new email.

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

' Create a new email.  The email we just read will be attached to this email.
Dim eForward As Chilkat.Email
Set eForward = Chilkat.NewEmail

success = eForward.AddTo("Chilkat Support","support@chilkatsoft.com")

eForward.FromAddress = "matt@someMailServer.com"
eForward.FromName = "Matt"
eForward.Subject = "This is an email with another email attached."

eForward.SetHtmlBody "<p>Hello, this is an email I'm forwarding to you.  See the attached email.</p>"

' Attach the email.
success = eForward.AttachEmail(email)

' 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!"