(Excel) Mailgun Send Email using MIME

See more Mailgun Examples

Send an email using MIME. This allows for the Chilkat email object to be used to construct the email. Then it can be sent using Mailgun.

For more information, see https://documentation.mailgun.com/en/latest/api-sending.html#sending

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.

' We're going to create an email that contains an .zip attachment,
' and also both plain-text and HTML alternative bodies.
' The HTML body will include an image.

Dim email As Chilkat.Email
Set email = Chilkat.NewEmail

' Adding attachments, HTML/plain-text bodies, etc can be done
' in any order:

' Add an attachment

contentType = email.AddFileAttachment("qa_data/hamlet.zip")
If (email.LastMethodSuccess <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' Add some headers:
email.Subject = "This is a complex email"
' Please change this email address before testing.

success = email.AddTo("Joe Example","joe@example.com")
email.From = "Mailgun Sandbox <postmaster@sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org>"

' Add a plain-text body:
Dim success As Boolean
success = email.AddPlainTextAlternativeBody("This is the plain-text body")

' Add an image that will be embedded in the HTML body.
success = email.AddRelatedFile2("qa_data/jpg/starfish.jpg","starfish.jpg")
If (success <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' Add an HTML body:

html = "<html><body><b>This is the HTML body</b><br><img src=""starfish.jpg""></body></html>"

success = email.AddHtmlAlternativeBody(html)

' ------------------------------------------------------------------------
' Send the above email using Mailgun

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

' Implements the following CURL command:

http.Login = "api"
http.Password = "api_password"'  500edc...

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = "/v3/sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org/messages.mime"
req.ContentType = "multipart/form-data"

req.AddParam "from","Mailgun Sandbox <postmaster@sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org>"
req.AddParam "to","Joe Example <joe@example.com>"
success = req.AddStringForUpload2("message","message.eml",email.GetMime(),"utf-8","application/octet-stream")


Set resp = http.SynchronousRequest("api.mailgun.net",443,True,req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "id": "<20210429234809.1.2D550E1C94D3D98F@sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org>",
'   "message": "Queued. Thank you."
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


id = jResp.StringOf("id")

message = jResp.StringOf("message")