#17 Blat and SQL server

open
nobody
None
5
2014-08-18
2005-03-13
Anonymous
No

I'm currently using CDOSYS to send emails from SQL
server, but its not working reliably.

I've been recommended Blat, and I know it can be
executed from an SQL stored procedure, but is it
possible for it to return an error code to indicate
whether the email address was correct, the email server
is correctly defined, and whether the mail was actually
sent?

Any help is appreciated!

Jez

Jez@tackarama.co.uk

Discussion

  • Chip
    Chip
    2005-03-16

    Logged In: YES
    user_id=800692

    Blat returns a zero when the mail is sent, and a value
    greater than zero when there is an error. Here is the list
    of error codes returned from Blat, and reasons --

    http://www.blat.net/examples/blat_return_codes.htm

    Chip