VBA Email validation (1 Viewer)

Hello1 · May 8, 2019

Is there a way to use a website like Verifalia but directly in VBA code so it checks if the Email is active/valid and everything else it can check?
Something like WinHttpRequest object for URL check?
I did find the

Code:

"vbscript.regexp" and
.Pattern = "^([a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+(\.[a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.([a-z]{2,})){1}(;[a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+(\.[a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.([a-z]{2,}))*$"

but it only checks if the email text is correct, I want also to know if the email is active and a mail can be delivered to it.

Thanks!

June7 · May 8, 2019

According to their website, Verifalia has an API. Although, VBA is not listed as supported language. If you are a subscriber, they should be able to guide you.

Otherwise, I think you will only learn that if you get delivery failure email.

Hello1 · May 8, 2019

Yup through Outlook I get it in the inbox but not really what I want.
I would like to write some code which would check if the email is active when the user enters an email for a customer, if not, then to put a msg box that the email is either wrong or not active or sth similar.

June7 · May 8, 2019

Review https://tools.verifyemailaddress.io/Articles/Ping/How_To_Ping_Email_Address
I expect programming that in VBA would involve Windows API functions.

That came from https://tools.verifyemailaddress.io/
They also have an API.

Hello1 · May 9, 2019

Yeah I saw that many have API but no idea how to implement that, Im researching

Edit: I dont need to do many checks, maximum 200 per month maybe. Saw somewhere that they offer for free up to 1000 email checks per month.

Edit: I found this but doesnt seem to work VB6 - Validate Email Address Syntax and Test Email Address

theDBguy · May 9, 2019

Hello1 said:
Is there a way to use a website like Verifalia but directly in VBA code so it checks if the Email is active/valid and everything else it can check?
Something like WinHttpRequest object for URL check?
I did find the

Code:

"vbscript.regexp" and .Pattern = "^([a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+(\.[a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.([a-z]{2,})){1}(;[a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+(\.[a-z0-9,!#\$%&'\*\+/=\?\^_`\{\|}~-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.([a-z]{2,}))*$"

but it only checks if the email text is correct, I want also to know if the email is active and a mail can be delivered to it.

Thanks!

Hi. Whenever I need to connect to a web service, I use this HttpRequestClass. Hope it helps...

FrederikLuski · Apr 17, 2024

They also have an API.
> 3 000 000 per month maybe. That came from

Code:

<a href="mailtester.ninja">MailTester Ninja</a>

I thinks I will try to manage it with their free REST API first 1 check/mn

theDBguy · Apr 17, 2024

FrederikLuski said:
They also have an API.
> 3 000 000 per month maybe. That came from

Code:

<a href="mailtester.ninja">MailTester Ninja</a>

I thinks I will try to manage it with their free REST API first 1 check/mn

Hi. Welcome to AWF!

Better late than never, right?

Gasman · Apr 17, 2024

theDBguy said:
Hi. Welcome to AWF!

Better late than never, right?

I thought it might just be spam for that particular product.

theDBguy · Apr 17, 2024

Gasman said:
I thought it might just be spam for that particular product.

We'll see. I'll keep an eye on it...

VBA Email validation (1 Viewer)

Hello1

Registered User.

June7

AWF VIP

Hello1

Registered User.

June7

AWF VIP

Hello1

Registered User.

theDBguy

I’m here to help

FrederikLuski

New member

theDBguy

I’m here to help

Gasman

Enthusiastic Amateur

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread