(Excel) Send Email With Attachments

Demonstrates how to send an email with 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.

' The mailman object is used for sending (SMTP) and receiving (POP3) email.
Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

' Set the SMTP server.
mailman.SmtpHost = "smtp.my-tls-mail-server.com"

' Set the SMTP login/password (if required)
mailman.SmtpUsername = "MY_SMTP_USERNAME"
mailman.SmtpPassword = "MY_SMTP_PASSWORD"

' Connect to SMTP port 465 using TLS.
mailman.SmtpSsl = True
mailman.SmtpPort = 465

' Create a new email object
Dim email As Chilkat.Email
Set email = Chilkat.NewEmail

email.Subject = "This is a test"
email.Body = "This is a test"
email.From = "Chilkat Support <support@chilkatsoft.com>"

success = email.AddTo("Chilkat Admin","admin@chilkatsoft.com")
' To add more recipients, call AddTo, AddCC, or AddBcc once per recipient.

' Add some attachments.
' The AddFileAttachment method returns the value of the content-type it chose for the attachment.

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

contentType = email.AddFileAttachment("qa_data/pdf/fishing.pdf")
If (email.LastMethodSuccess <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' Call SendEmail to connect to the SMTP server and send.
' The connection (i.e. session) to the SMTP server remains
' open so that subsequent SendEmail calls may use the
' same connection.  
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 "Mail with attachments sent!"