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 Removed),, , "Test
of bad email address", "Test"

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

Thanks, another reason to hate spammers...

"TC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>