My Idea is to have on column with my email addresses then the second for the result code you get from the json returned value
Still vague so without the requested good enough description the better is to attach a workbook with the exact expected results
according to all different cases you have met using manually the website.
Once done I will write only a single procedure, the one without a key, working only under Windows with good enough readers,
the slow way for such slow website but to be trashed the day you buy a key, you will need someone else ! (1)
Or you can share a key in a private message for my testing purposes in order you can directly get the correct procedure version,
you may ask the website to get a temp key valid for few days …
Throttle is 100k a day so 100 rows is < 1m30sec
According to my manual tests, with a classic VBA way you can find within this forum like in other VBA forums sites
it should be a miracle if under 3 minutes as this slow website needs sometimes more than 4 seconds to answer for a single mail,
not be surprised with a key if it needs between 7 and 10 minutes for 100 mails to check !
May be faster with a specific pro VBA / Windows way on a good enough computer …
(1) Should work with a key, you just will have to mod two codelines but could be the slowest way versus efficient key versions.
