(Excel) SendGrid Send Email with Additional BCC Recipient

See more SendGrid Examples

Sends an email to a recipient, but also with an additional BCC recipient.

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

' The following JSON is sent in the request body.

' {
'   "personalizations": [
'     {
'       "to": [
'         {
'           "email": "recipient@example.com"
'         }
'       ]
'       "bcc": [
'         {
'           "email": "recipient2@example2.com"
'         }
'       ]
'     }
'   ],
'   "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")
success = json.UpdateString("personalizations[0].bcc[0].email","recipient2@example2.com")
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