xp_Sendmail does everything but actually sending the message

[John Milano]

I have everything set up with SQL Server 2000 and Outlook 2000 and the
procedure works fine but the message sits in my inbox. When it open
the e-mail it says this message has not been sent. I just click send
and the e-mail sends. Is there any reason I have to manually sent the
e-mail after the xp_sendmail procedure works and should send the
e-mail itself.

Thanks
John

[Simon Hayes]

jj******@comcast.net (John Milano) wrote in message news:<16**************************@posting.google. com>...

I have everything set up with SQL Server 2000 and Outlook 2000 and the
procedure works fine but the message sits in my inbox. When it open
the e-mail it says this message has not been sent. I just click send
and the e-mail sends. Is there any reason I have to manually sent the
e-mail after the xp_sendmail procedure works and should send the
e-mail itself.

Thanks
John

There is a lot of troubleshooting information here:

http://support.microsoft.com/default...&Product=sql2k

Simon