(Excel) Office365 POP3 Login with OAuth2 Authentication

Demonstrates how to authenticate using OAuth2 using the POP3 protocol with outlook.office365.com.

Note: This example requires Chilkat v9.5.0.83 or greater.

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.

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

mailman.MailHost = "outlook.office365.com"
mailman.MailPort = 995
mailman.PopSsl = True

' Use your O365 email address here.
mailman.PopUsername = "OFFICE365_EMAIL_ADDRESS"

' When using OAuth2 authentication, leave the password empty.
mailman.PopPassword = ""

' Load 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 jsonToken.LastErrorText
    Exit Sub
End If

mailman.OAuth2AccessToken = jsonToken.StringOf("access_token")

' Make the TLS connection to the outlook.office365.com POP3 server.
success = mailman.Pop3Connect()
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

' Authenticate using XOAUTH2
success = mailman.Pop3Authenticate()
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

' Find out how many emails are on the server..

numEmails = mailman.CheckMail()
If (numEmails < 0) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

' Examine the POP3 session log:
Debug.Print mailman.Pop3SessionLog

' The POP3 session log will look something like this:

' **** Connected to pop.gmail.com:995
' < +OK The Microsoft Exchange POP3 service is ready. [QwBIADIAUABSADEAOABD...YwBvAG0A]
' > AUTH XOAUTH2
' < + 
' > <base64 string in XOAUTH2 format>
' < +OK User successfully authenticated.
' > STAT
' < +OK 3 375302

' End the POP3 session and close the connection to the GMail server.
success = mailman.Pop3EndSession()
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

Debug.Print "Finished."