(Excel) GMail SMTP port 587 with "less secure" Password Authentication

Send email using GMail's SMTP server on port 587 (SSL via STARTTLS).

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' Use the GMail SMTP server
' This example assumes your GMail account allows for "less secure apps" to use 
' SMTP username/password authentication.
' For OAuth2 authentication, see GMail SMTP with OAuth2 Authentication
mailman.SmtpHost = "smtp.gmail.com"
mailman.SmtpPort = 587
mailman.StartTLS = True

' Set the SMTP login/password.
mailman.SmtpUsername = "chilkat.support"
mailman.SmtpPassword = "myPassword"

' 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 <chilkat.support@gmail.com>"
Dim success As Boolean
success = email.AddTo("Chilkat","support@chilkatsoft.com")

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

Debug.Print "Email sent."