(Excel) SendGrid Hello World -- Send Simple Email to Single Recipient

See more SendGrid Examples

Sends an email to a single recipient using SendGrid.

For more information, see https://sendgrid.com/docs/for-developers/sending-email/curl-examples/

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl --request POST \
'   --url https://api.sendgrid.com/v3/mail/send \
'   --header 'Authorization: Bearer YOUR_API_KEY' \
'   --header 'Content-Type: application/json' \
'   --data '{"personalizations": [{"to": [{"email": "recipient@example.com", "name": "Recipient Name"}]}],"from": {"email": "sendeexampexample@example.com"},"subject": "Hello, World!","content": [{"type": "text/plain", "value": "Heya!"}]}'

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON

' The following JSON is sent in the request body.

' {
'   "personalizations": [
'     {
'       "to": [
'         {
'           "email": "recipient@example.com",
'           "name": "Recipient Name"
'         }
'       ]
'     }
'   ],
'   "from": {
'     "email": "sendeexampexample@example.com"
'   },
'   "subject": "Hello, World!",
'   "content": [
'     {
'       "type": "text/plain",
'       "value": "Heya!"
'     }
'   ]
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("personalizations[0].to[0].email","recipient@example.com")
' The "name" is optional.
success = json.UpdateString("personalizations[0].to[0].name","Recipient Name")
success = json.UpdateString("from.email","sendeexampexample@example.com")
success = json.UpdateString("subject","Hello, World!")
success = json.UpdateString("content[0].type","text/plain")
success = json.UpdateString("content[0].value","Heya!")

' Adds the "Authorization: Bearer YOUR_API_KEY" header.
http.AuthToken = "YOUR_API_KEY"
http.SetRequestHeader "Content-Type","application/json"


Set resp = http.PostJson3("https://api.sendgrid.com/v3/mail/send","application/json",json)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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