xp_sendmail | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Hello – I have outlook express (not outlook) installed on a Win2000 server running SQL 2000. I am using SQL Agent mail to notify me if an agent job cancels. This works very well. I am now trying to use SQL Mail and xp_sendmail to send the results of a query to a user. To start with I just want to see xp_sendmail send an email to an operator from Query Analyzer. I am using – EXEC xp_sendmail ‘Brad’, ‘Test of SQL sendmail.’ I am getting the following error "Either there is no default mail client or the current mail client cannot fulfill the messaging request" Someone had told me to use Outlook rather than Outlook Express for xp_sendmail. And then go into IE and make sure Outlook (not Outlook Express) is set as the email program. The problem is that my company will not allow me to install Outlook so I am stuck with Outlook Express. Is there a way to make this work with Outlook Express?
Outlook Express does not work with SQL Mail. You could use something like xp_smtp_sendmail:
http://www.sqldev.net/xp/xpsmtp.htm /Argyle
You need MS Outlook2000 with SQL2000 mail.
Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556 to configure sqlmail. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231 – FAQ about common mail problems.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886 – common mail problems.
And if you want to use alternative follow as Argyle suggested. _________
Satya SKJ

I am currently using the one given by Argyle. And so far, it’s working fine.<br /><br />Jon M [<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]