Hi everyone,
I stumbled upon this thread while researching Excel VBA integrations for email workflows—super relevant for my own projects! As someone who's been deep into building email tools, I wanted to chime in with an alternative that might complement or even streamline what you're doing with MailTester.Ninja.
If you're validating email lists for sign-ups, testing, or automation (like in CI/CD or bulk verifications), check out
Boomlify —a developer-first temporary email service I built. It's designed exactly for scenarios like this: generating disposable inboxes on the fly to test deliverability, catch bounces, or simulate real-world email flows without risking your main addresses. Here's how it ties in:
- **API for VBA/Excel Automation**: Boomlify's RESTful API is super straightforward to integrate via VBA (similar to MailTester's endpoints). You can create temp emails programmatically, fetch messages (including verification codes or errors), and even manage credits—all with JWT auth and rate limits scaling from 60 RPM (free tier) up to 1,200 RPM (Ultra Pro). For example, loop through your Column A emails, spin up a Boomlify inbox for each, send a test from your app, and pull results into Column B. No freezing Excel—it's async-friendly, and reading/fetching is free (credits only for creations: 1 for short-lived, 15 for permanent).
- **Validation Tie-In**: While not a pure validator like MailTester, Boomlify uses Gmail-based infrastructure for rock-solid deliverability checks. You can extend inbox lifespans up to 2+ months, preview messages in a dashboard (or API), and even forward to Telegram for real-time alerts on bounces/invalid responses. Pair it with MailTester: Validate first, then test-send via Boomlify for end-to-end verification.
- **Excel-Specific Workflow**: In VBA, you'd use something like this quick snippet to hit the API (adapt for your sheet; assumes emails in A2:A100, results in B):
```vba
Sub ValidateWithBoomlify()
Dim ws As Worksheet
Set ws = ActiveSheet
Dim i As Long
Dim email As String
Dim apiKey As String ' Your Boomlify API key from dashboard
Dim url As String
Dim http As Object
Set http = CreateObject("MSXML2.XMLHTTP")
For i = 2 To 100 ' Adjust row range
email = ws.Cells(i, 1).Value
If email = "" Then Exit For
' Create temp inbox for testing this email
url = "
https://api.boomlify.com/v1/emails/create?time=1hour&domain=boomlify.com" ' Customize params
http.Open "POST", url, False
http.setRequestHeader "Authorization", "Bearer " & apiKey
http.setRequestHeader "Content-Type", "application/json"
http.Send '{"email": "' & email & '"}' ' Pass email if needed for custom
If http.Status = 200 Then
Dim response As String
response = http.responseText
' Parse JSON (use VBA-JSON lib or simple InStr for status)
If InStr(response, "valid") > 0 Or InStr(response, "delivered") > 0 Then
ws.Cells(i, 2).Value = "Valid/Delivered"
Else
ws.Cells(i, 2).Value = "Invalid/Bounce"
End If
Else
ws.Cells(i, 2).Value = "API Error: " & http.Status
End If
Application.Wait Now + TimeValue("0:00:01") ' 1-sec throttle; adjust for your limits
Next i
End Sub
```
This is bare-bones—add error handling, JSON parsing (grab a free VBA-JSON module), and your key. For bulk (100 rows), it flies under 1-2 mins on paid tiers (100k/day throttle, no per-minute cap like free MailTester). Free tier gives 50 daily credits + 150 mailboxes total, with bonuses on upgrade (e.g., +1,500 credits to Basic).
- **Why It Helps Here**: Unlike pure validators, Boomlify handles the full cycle—create, receive, analyze—for privacy-safe testing. No spam in your real inbox, custom domains for branded sims, and 2FA/OTP management built-in. For teams, scale to 5k mailboxes (Ultra Pro) with 90-day retention. Pricing starts free (no card), scales affordably ($1=1k credits), and it's ad-free on paid.
Full API docs:
https://boomlify.com/en/temp-mail-api-docs (interactive testing, no setup). If you're hitting MailTester's 1/min limit, this could cut your wait times dramatically while adding preview/forwarding perks. I've used it in my own VBA scripts for app testing—game-changer for devs avoiding email fatigue.
Marc L, love your point on attachments for clarity—happy to share a sample workbook if it helps! KIoPloio, that URL approach is solid; Boomlify's is even simpler (UUID-based fetches). Anyone tried blending APIs like this for hybrid validation?
Thoughts? Collab ideas welcome—let's make email workflows painless.
