(Excel) Mailgun Send Simple Email

See more Mailgun Examples

Send a simple email 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.

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

' Implements the following CURL command:

' curl -s --user 'api:500edc...' 
' 	 https://api.mailgun.net/v3/sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org/messages 
' 	 -F from='Mailgun Sandbox <postmaster@sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org>' 
' 	 -F to='Joe Example <joe@example.com>' 
' 	 -F subject='Hello Joe Example' 
' 	 -F text='Congratulations Joe Example, you just sent an email with Mailgun!  You are truly awesome!'

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

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"
req.ContentType = "multipart/form-data"

req.AddParam "from","Mailgun Sandbox <postmaster@sandbox0e542e4c577f4bbb98c8bf6b6bca727b.mailgun.org>"
req.AddParam "to","Joe Example <joe@example.com>"
req.AddParam "subject","Hello Joe Example"
req.AddParam "text","Congratulations Joe Example, you just sent an email with Mailgun!  You are truly awesome!"


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
Dim success As Boolean
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")