(Excel) Outlook Send HTML Email

This example sends an HTML email. Other examples exist for:

Sending plain-text email.
Sending HTML email with embedded images.
Sending email with attachments.
Sending HTML email with embedded images and attachments.

Note: This example requires Chilkat v9.5.0.68 or greater.

Download Excel Class Modules

Chilkat Excel Class Modules

' Important: This example requires Chilkat v9.5.0.68 or greater.

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

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

' Use your previously obtained access token here:
' See the following examples for getting an access token:
'    Get Microsoft Graph OAuth2 Access Token (Azure AD v2.0 Endpoint).
'    Get Microsoft Graph OAuth2 Access Token (Azure AD Endpoint).
'    Refresh Access Token (Azure AD v2.0 Endpoint).
'    Refresh Access Token (Azure AD Endpoint).

http.AuthToken = "MICROSOFT_GRAPH_ACCESS_TOKEN"

' To send mail, we'll POST to the following endpoint:
' 
' POST /users/{id | userPrincipalName}/sendMail
' 
' (The special keyword "me" may be used in place of a principal name.)
' 

' This example will send HTML email containing the following HTML body:

' 	<html>
' 	<head>
' 	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
' 	<meta content="text/html; charset=utf-8">
' 	</head>
' 	<body bgcolor="#FFFFFF">
' 	<font face="Calibri">This is a test <b>HTML email</b>.<br>
' 	</font>
' 	</body>
' 	</html>

' Build the HTML body...

bCrlf = True
Dim sbHtmlBody As Chilkat.StringBuilder
Set sbHtmlBody = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbHtmlBody.AppendLine("<html>",bCrlf)
success = sbHtmlBody.AppendLine("<head>",bCrlf)
success = sbHtmlBody.AppendLine("<meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">",bCrlf)
success = sbHtmlBody.AppendLine("<meta content=""text/html; charset=utf-8"">",bCrlf)
success = sbHtmlBody.AppendLine("</head>",bCrlf)
success = sbHtmlBody.AppendLine("<body bgcolor=""#FFFFFF"">",bCrlf)
success = sbHtmlBody.AppendLine("<font face=""Calibri"">This is a test <b>HTML email</b>.<br>",bCrlf)
success = sbHtmlBody.AppendLine("</font>",bCrlf)
success = sbHtmlBody.AppendLine("</body>",bCrlf)
success = sbHtmlBody.AppendLine("</html>",bCrlf)

' The body of the POST request contains JSON that specifies the email subject, body,
' recipients, etc.  This example will build the following JSON HTML email:
' 

' 	{
' 	  "message": {
' 	    "subject": "Sample HTML Email",
' 	    "body": {
' 	      "contentType": "html",
' 	      "content": "The HTML body goes here..."
' 	    },
' 	    "toRecipients": [
' 	      {
' 	        "emailAddress": {
' 		  "name": "Chilkat Software",
' 	          "address": "admin@chilkat.io"
' 	        }
' 	      },
' 	      {
' 	        "emailAddress": {
' 	          "address": "chilkat.support@gmail.com"
' 	        }
' 	      }
' 	    ],
' 	    "ccRecipients": [
' 	      {
' 	        "emailAddress": {
' 		  "name": "Chilkat Blog",
' 		  "address": "admin@cknotes.com"
' 	        }
' 	      }
' 	    ]
' 	  },
' 	  "saveToSentItems": true
' 	}
' 

' Build the above JSON.
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("message.subject","Sample HTML email")
success = json.UpdateString("message.body.contentType","html")
success = json.UpdateString("message.body.content",sbHtmlBody.GetAsString())
success = json.UpdateString("message.toRecipients[0].emailAddress.name","Chilkat Software")
success = json.UpdateString("message.toRecipients[0].emailAddress.address","admin@chilkat.io")
success = json.UpdateString("message.toRecipients[1].emailAddress.address","chilkat.support@gmail.com")
success = json.UpdateString("message.ccRecipients[0].emailAddress.name","Chilkat Blog")
success = json.UpdateString("message.ccRecipients[0].emailAddress.address","admin@cknotes.com")
success = json.UpdateBool("saveToSentItems",True)

' -------------------------------------------------------------
' Important: This example requires Chilkat v9.5.0.68 or greater.
' -------------------------------------------------------------

' Send the HTTP POST (i.e. send the HTML email)

Set resp = http.PostJson2("https://graph.microsoft.com/v1.0/me/sendMail","application/json",json.Emit())
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' The send succeeded if the response status code = 202.
' In the success case, there is no response body.  (We just get the response code to know that it succeeded.)
If (resp.StatusCode <> 202) Then
    success = json.Load(resp.BodyStr)
    json.EmitCompact = False
    Debug.Print json.Emit()
    Debug.Print "Failed, response status code = "; resp.StatusCode
Else
    Debug.Print "Outlook HTML Mail Sent."
End If