Error when using XP_SENDMAIL

[elmorro]

Hi all,
I get the following message when I use xp_sendmail:

Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request.

How can I fix this problem?

Thanks in advance,
elmorro

 

[JohnBates]

elmorro,

Assuming you have SQL Server 2000, Install Outlook 2000.
I have not been able to get xp_sendmail to work with any other mail client.

(You may also need to have Outlook open before the xp_sendmail runs)

Try these things and let us know what happened.

John