How can I get an error message if the email does not exist?

[Ed]

I use the following line of code. It sends an email to the address. It works
even if the email address is bad.

How can I get an error message if the email does not exist?

DoCmd.SendObject acSendNoObject, , acFormatTXT, (e-mail address removed),, , "Test
of bad email address", "Test"

 

[TC]

You can't. There is literally *no way* to tell, programatically, that a
given email address is *invalid* (in the sense that the address has the
correct format for an email address, but it does not actually exist at
the specified host).

There used to be a way: the SMTP 'VRFY' command. But that is virtually
unusable now, due to its use by spammers to harvest lists of valid
email addresses.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Ed]

Thanks, another reason to hate spammers...