(Excel) Get SpamAssassin Score for an Email

Uses Postmark’s spam API (a RESTfull interface to the SpamAssassin filter tool) to analyze an email to get a spam score.

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.

' First build an email to check.
Dim email As Chilkat.Email
Set email = Chilkat.NewEmail
email.Subject = "this is a test"
email.From = "support@chilkatsoft.com"
success = email.AddTo("John Doe","john@example.com")
success = email.AddPlainTextAlternativeBody("this is a test")
success = email.AddHtmlAlternativeBody("<html><body><b>Hello John!</b><p>This is a test</p></body></html>")
success = email.AddFileAttachment2("qa_data/jpg/starfish.jpg","image/jpeg")

' Check this email by implementing this curl command:

' curl -X POST "https://spamcheck.postmarkapp.com/filter"
' -H "Accept: application/json"
' -H "Content-Type: application/json"
' -v
' -d '{"email":"raw dump of email", "options":"short"}'

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("email",email.GetMime())
success = json.UpdateString("options","short")

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

Set resp = http.PostJson3("https://spamcheck.postmarkapp.com/filter","application/json",json)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "response status code = "; resp.StatusCode
Debug.Print "response body: "
Debug.Print resp.BodyStr