(Excel) Yahoo IMAP Authentication using OAuth2 Access Token

See more Yahoo Mail Examples

Demonstrates how to do IMAP OAuth2 authentication for Yahoo (or any other IMAP mail server supporting 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 GMail access token file."
    Exit Sub
End If


accessToken = json.StringOf("access_token")

' Do OAuth2 authentication by using the access token as the password in the Login method below...
Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

imap.Ssl = True
imap.Port = 993

' Connect to the Yahoo IMAP server.
success = imap.Connect("imap.mail.yahoo.com")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Indicate that XOAUTH2 authentication is to be used:
imap.AuthMethod = "XOAUTH2"

' Login
' Use the email address of the GMail account that granted authorization.
success = imap.Login("user@yahoo.com",accessToken)
If (success <> True) Then
    Debug.Print imap.LastErrorText
Else
    Debug.Print "Successfully authenticated with Yahoo IMAP using XOAUTH2!"
End If