sp_sendmail

19 Jan 2006 12:59 AM

Hoosbruin

How do I check that the sp_sendmail went thru. I looking for away to verify
that the mail went out thru Exchange and didn't get a non-deliverable for
some reason. The subject has the same format when we use sp_sendmail.

Thanks.

19 Jan 2006 12:59 PM

John Bell

nHi

I assume you are using xp_sendmail?

If you maintain a list of sent emails, then you can compare mails comming
into specific mailbox using the xp_findnextmsg and xp_readmail, but email can
not be guaranteed to return a non-delivery message.

John

Show quoteHide quote

"Hoosbruin" wrote:

>
> How do I check that the sp_sendmail went thru. I looking for away to verify
> that the mail went out thru Exchange and didn't get a non-deliverable for
> some reason. The subject has the same format when we use sp_sendmail.
>
>
> Thanks.
>
>
>