(Excel) SES Send HTML Email

See more Amazon SES Examples

Sends a simple HTML email to one or more recipients.

See SES SendEmail for more information.

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.

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to the Amazon AWS REST server.
' such as https://email.us-west-2.amazonaws.com/

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("email.us-west-2.amazonaws.com",port,bTls,bAutoReconnect)

' Provide AWS credentials for the REST call.
Dim authAws As Chilkat.AuthAws
Set authAws = Chilkat.NewAuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "AWS_SECRET_KEY"
' the region should match our URL above..
authAws.Region = "us-west-2"
authAws.ServiceName = "ses"

Dim success As Boolean
success = rest.SetAuthAws(authAws)

success = rest.AddQueryParam("Action","SendEmail")

success = rest.AddQueryParam("Message.Body.Html.Data","<html><body><p>This is a simple <b>HTML Email</b></p></body></html>")
success = rest.AddQueryParam("Message.Body.Html.Charset","utf-8")

success = rest.AddQueryParam("Message.Subject.Data","Sample HTML SES email")
success = rest.AddQueryParam("Message.Subject.Charset","utf-8")

' Add up to 100 TO, CC, and BCC recipients.
' If your SES account is still in the sandbox, you also must verify every recipient email address except for the recipients 
' provided by the Amazon SES mailbox simulator. (See http://docs.aws.amazon.com/ses/latest/DeveloperGuide/mailbox-simulator.html)
success = rest.AddQueryParam("Destination.ToAddresses.member.1","success@simulator.amazonses.com")
' Please do not test by sending email to Chilkat (Thank You!)
' Please do not test by sending email to Chilkat (Thank You!)
' Please do not test by sending email to Chilkat (Thank You!)
success = rest.AddQueryParam("Destination.CcAddresses.member.1","support@chilkatsoft.com")
success = rest.AddQueryParam("Destination.CcAddresses.member.2","somebody@yahoo.com")
success = rest.AddQueryParam("Destination.BccAddresses.member.1","somebody@gmail.com")

success = rest.AddQueryParam("Source","admin@chilkatdownload.com")

' Because there may be a large amount of data in the query params, use a POST
' where the params are sent in the body of the HTTP Request.

responseXml = rest.FullRequestFormUrlEncoded("POST","/")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' A successful response will have a status code equal to 200.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body: "; responseXml
    Exit Sub
End If

' Examine the successful XML response.
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(responseXml)
Debug.Print xml.GetXml()

' To get the MessageId
Debug.Print "MessageId: "; xml.ChilkatPath("SendEmailResult|MessageId|*")

' A sample successful response:
' <?xml version="1.0" encoding="utf-8" ?>
' <SendEmailResponse xmlns="http://ses.amazonaws.com/doc/2010-12-01/">
'     <SendEmailResult>
'         <MessageId>010101579081d2c1-043c693f-5a23-4c64-a8c1-66187d3725a0-000000</MessageId>
'     </SendEmailResult>
'     <ResponseMetadata>
'         <RequestId>e2b5b480-8a4e-11e6-85cd-21b1f1f6d432</RequestId>
'     </ResponseMetadata>
' </SendEmailResponse>