(Excel) Send GMail with Attachments

Demonstrates how to send an email containing attachments 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())

' Add some attachments..

mimeType = email.AddFileAttachment("qa_data/helloWorld.pdf")
If (email.LastMethodSuccess <> True) Then
    Debug.Print "Failed to add PDF attachment."
    Exit Sub
End If

mimeType = email.AddFileAttachment("qa_data/msword/sample2.docx")
If (email.LastMethodSuccess <> True) Then
    Debug.Print "Failed to add MS-Word attachment."
    Exit Sub
End If

' OK.. we now have an HTML email with 2 attachments..
Dim sbMime As Chilkat.StringBuilder
Set sbMime = Chilkat.NewStringBuilder
success = email.GetMimeSb(sbMime)

' Send the email.  (GMail has a 5MB limit on the total email size.)
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.AuthToken = "GMAIL-ACCESS-TOKEN"

' Send using the simple upload request for the Gmail API

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

sendGzipped = True

Set resp = http.PTextSb("POST",url,sbMime,"utf-8","message/rfc822",False,sendGzipped)
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"
'  ]
' }