(Excel) Send HTML Email with Attachments

Demonstrates how to send an HTML email with file attachments.

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.

Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

mailman.SmtpHost = "smtp.my-starttls-mail-server.com"

mailman.SmtpUsername = "MY-SMTP-USERNAME"
mailman.SmtpPassword = "MY-SMTP-PASSWORD"

mailman.StartTLS = True
mailman.SmtpPort = 587

' Create a new email object
Dim email As Chilkat.Email
Set email = Chilkat.NewEmail
email.Subject = "Test SMTP API to Send HTML Email with Attachments"
email.From = "Joe Programmer <joe@my-starttls-mail-server.com>"
Dim success As Boolean
success = email.AddTo("Chilkat Support","support@chilkatsoft.com")

' Add a plain-text alternative body, which will likely never be seen.
' (It is shown if the receiving email client is incapable of displaying HTML email.)
success = email.AddPlainTextAlternativeBody("This is a plain-text alternative body...")

' Our HTML will include an image, so add the related image here.

contentIdStarfish = email.AddRelatedFile("qa_data/jpg/starfish.jpg")
If (email.LastMethodSuccess <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' The src attribute for the image tag is set to the contentIdStarfish:
Dim sbHtml As Chilkat.StringBuilder
Set sbHtml = Chilkat.NewStringBuilder
success = sbHtml.Append("<html><body><p>This is an HTML email with an embedded image.</p>")
success = sbHtml.Append("<p><img src=""cid:CONTENT_ID_STARFISH"" /></p></body></html>")

numReplacements = sbHtml.Replace("CONTENT_ID_STARFISH",contentIdStarfish)

success = email.AddHtmlAlternativeBody(sbHtml.GetAsString())

' Finally, add some attachments to the email.
' Add a file attachment.

success = email.AddFileAttachment2("qa_data/pdf/fishing.pdf","application/pdf")
If (success <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' Add an attachment where the content is contained in a string.

content = "This is the content of the 2nd attached file."
success = email.AddStringAttachment("someText.txt",content)

' Send the HTML email.
success = mailman.SendEmail(email)
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 "HTML email with attachments sent!"