(Excel) Office365 IMAP with OAuth2 Authentication

Demonstrates how to authenticate using OAuth2 with outlook.office365.com.

Download Excel Class Modules Chilkat Excel Class Modules

' An Office365 OAuth2 access token must first be obtained prior
' to running this code.

' Getting the OAuth2 access token for the 1st time requires the O365 account owner's 
' interactive authorizaition via a web browser.  Afterwards, the access token
' can be repeatedly refreshed automatically.

' See the following examples for getting and refreshing an OAuth2 access token

' Get Office365 SMTP/IMAP/POP3 OAuth2 Access Token
' Refresh Office365 SMTP/IMAP/POP3 OAuth2 Access Token

' First get our previously obtained OAuth2 access token.
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/office365.json")
If (success = False) Then
    Debug.Print "Failed to open the office365 OAuth JSON file."
    Exit Sub
End If

Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

imap.Ssl = True
imap.Port = 993

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

' Use OAut2 authentication.
imap.AuthMethod = "XOAUTH2"

' Login using our username (i.e. email address) and the access token for the password.
success = imap.Login("OFFICE365_EMAIL_ADDRESS",jsonToken.StringOf("access_token"))
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

Debug.Print "O365 OAuth authentication is successful."

' Do something...
success = imap.SelectMailbox("Inbox")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Your application can continue to do other things in the IMAP session....

' When finished, logout and close the connection.
success = imap.Logout()
success = imap.Disconnect()

Debug.Print "Finished."