(Excel) Send GMail using REST API

Demonstrates how to send an email using the GMail REST API.

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.

' Use the Chilkat Email API to create or load an email.
Dim email As Chilkat.Email
Set email = Chilkat.NewEmail

' The From name/address don't need to be specified. 
' GMail will automatically use your Gmail address if the following 2 lines are omitted.
email.FromName = "My Name"
email.FromAddress = "my_account_name@gmail.com"

success = email.AddTo("John Smith","somebody@somewhere.com")
' To add more recipients, make additional calls to AddTo or AddCC, one per recipient...

email.Subject = "This is a test GMail email created using Chilkat."
email.Charset = "utf-8"
success = email.AddPlainTextAlternativeBody("This is a test")

' Create an HTML email body with an embedded image.

cid = email.AddRelatedFile("qa_data/jpg/starfish.jpg")
Dim sbHtml As Chilkat.StringBuilder
Set sbHtml = Chilkat.NewStringBuilder
success = sbHtml.Append("<html><body>This is a <b>test</b><br><img src=""cid:STARFISH_CID""/></body></html>")

numReplacements = sbHtml.Replace("STARFISH_CID",cid)

success = email.AddHtmlAlternativeBody(sbHtml.GetAsString())

' OK.. we now have an HTML email with an embedded JPG image
' We'll need to get the full MIME of the email encoded to a base64url string.
Dim sbMime As Chilkat.StringBuilder
Set sbMime = Chilkat.NewStringBuilder
success = email.GetMimeSb(sbMime)
success = sbMime.Encode("base64url","utf-8")

' The body of the HTTP request will be JSON..
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateSb("raw",sbMime)

' Send the email...
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.AuthToken = "GMAIL-ACCESS-TOKEN"


url = "https://www.googleapis.com/gmail/v1/users/me/messages/send"

Set resp = http.PostJson3(url,"application/json",json)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' A status code of 200 indicates success.
Debug.Print "Response status code: "; resp.StatusCode
Debug.Print "Response body:"
Debug.Print resp.BodyStr

' The response body contains JSON.
' Use the online tool at Generate JSON Parsing Code
' to generate JSON parsing code.

' A sample successful JSON response:

' {
'  "id": "166f0d4ac39e50bf",
'  "threadId": "166f0d4ac39e50bf",
'  "labelIds": [
'   "SENT"
'  ]
' }