(Excel) Yahoo Mail Send using OAuth2 Access Token

See more Yahoo Mail Examples

Demonstrates how to send email using Yahoo and OAuth2 authentication. This example assumes an OAuth2 access token was previously obtained.

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.

' See Get Yahoo Mail OAuth2 Access Token for Desktop App 
' for sample code showing how to obtain a Yahoo Mail access token.

' In this example, our access token was previously saved to the following file which contains JSON like this:
' {
'   "access_token": "kCVQdnOdul...LHucA--",
'   "refresh_token": "AIenVXETSo0jklFBVkPS8vVm8E.Ej9ToRG.xDbDYmZ65WIs5t6CZhDrD",
'   "expires_in": 3600,
'   "token_type": "bearer",
'   "xoauth_yahoo_guid": "HGDQCVF5JB4YDOWHITQJFBHCWA"
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

success = json.LoadFile("qa_data/tokens/yahooMail.json")
If (success <> True) Then
    Debug.Print "Failed to load Yahoo access token file."
    Exit Sub
End If


accessToken = json.StringOf("access_token")

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

' Set the properties for the Yahoo SMTP server:
mailman.SmtpHost = "smtp.mail.yahoo.com"
mailman.SmtpPort = 465
mailman.SmtpSsl = True

' The SMTP username should be the Yahoo email address of the user's account that authorized your app to send email.
mailman.SmtpUsername = "user@yahoo.com"
mailman.OAuth2AccessToken = accessToken

' 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 = "Joe User <user@yahoo.com>"
Dim success As Boolean
success = email.AddTo("Chilkat Admin","admin@chilkatsoft.com")
' To add more recipients, call AddTo, AddCC, or AddBcc once per recipient.

' 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

' You may close the connection here.  If the connection is kept open, 
' the next call to mailman.SendEmail will continue using the already-established connection
' (and automatically re-connect if needed).
success = mailman.CloseSmtpConnection()
If (success <> True) Then
    Debug.Print "Connection to SMTP server not closed cleanly."
End If

Debug.Print "Email Sent via Yahoo with OAuth2 authentication."