(Excel) SendGrid HTML Email with Embedded Images

See more SendGrid Examples

Demonstrates how to send an HTML email with embedded images using SendGrid.

Download Excel Class Modules

Chilkat Excel Class Modules

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' First.. load a JPG file and build an HTML img tag with the JPG data inline encoded.
' Our HTML img tag will look like this:
' <img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEA3ADcAA..." alt="" style="border-width:0px;" />
Dim bdJpg As Chilkat.BinData
Set bdJpg = Chilkat.NewBinData
success = bdJpg.LoadFile("qa_data/jpg/starfish.jpg")
If (success = False) Then
    Debug.Print "Failed to load JPG file."
    Exit Sub
End If

' Note: HTML containing embedded base64 image data may not be visible in all email clients.
' For example, GMail might not display the image, but viewing in Outlook might be OK.
Dim sbHtml As Chilkat.StringBuilder
Set sbHtml = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbHtml.Append("<html><body><b>This is a test<b><br /><img src=""data:image/jpeg;base64,")
' Append the base64 image data to sbHtml.
success = bdJpg.GetEncodedSb("base64",sbHtml)
success = sbHtml.Append(""" alt="""" style=""border-width:0px;"" /></body></html>")

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("personalizations[0].to[0].email","matt@chilkat.io")
success = json.UpdateString("personalizations[0].to[0].name","Matt")
success = json.UpdateString("from.email","admin@chilkatsoft.com")
success = json.UpdateString("subject","Test HTML email with images")
success = json.UpdateString("content[0].type","text/html")
success = json.UpdateSb("content[0].value",sbHtml)

http.AuthToken = "SENDGRID_API_KEY"

Set resp = http.PostJson3("https://api.sendgrid.com/v3/mail/send","application/json",json)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
Else
    Debug.Print "response status code: "; resp.StatusCode
    ' Display the response.
    ' If successful, the response code is 202 and the response body string is empty.
    ' (The response body string may also be empty for error response codes.)
    Debug.Print resp.BodyStr

End If