Why xp_sendmail Doesn't Work With Hotmail?

[mike]

Using the Query Analyzer, I issued the statement "EXEC xp_sendmail
'a*****@hotmail.com, 'Test.'" and received 'email sent' confirmation.
But, my email was never received.

I used the same statement to send mail to a Yahoo account and it was
received.

Is there a way to be able to send email using SQL xp_sendmail to a
Hotmail account?

Thank you very much

mike

[Erland Sommarskog]

mike (mj****@yahoo.com) writes:

Using the Query Analyzer, I issued the statement "EXEC xp_sendmail
'a*****@hotmail.com, 'Test.'" and received 'email sent' confirmation.
But, my email was never received.

I used the same statement to send mail to a Yahoo account and it was
received.

Is there a way to be able to send email using SQL xp_sendmail to a
Hotmail account?

I would guess that your mail fell victim to some filter on Hotmail.

The problem is in any case not likely to be with xp_sendmail, but
somewhere further along the line.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp