(Excel) Create GMail Draft

Demonstrates how to create a new GMail draft email.

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
email.Subject = "This is a test GMail email created using Chilkat."
email.Charset = "utf-8"
success = email.AddPlainTextAlternativeBody("This is a test")
success = email.AddHtmlAlternativeBody("<html><body><p>This is a <b>test</b></body></html>")

' 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("message.raw",sbMime)

' Upload the email to GMail as a draft.
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.AuthToken = "GMAIL-ACCESS-TOKEN"


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

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": "r-2607584557788895307",
'  "message": {
'   "id": "166f09932c662e93",
'   "threadId": "166f09932c662e93",
'   "labelIds": [
'    "DRAFT"
'   ]
'  }
' }