Problems with xp_sendmail
-
Hello, I am having trouble sending an email from a stored procedure in MS-SQL 2005. Here is the error: xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. The box is a server and does not have Outlook loaded but does have "Database Mail" loaded along with the SMTP mail for IIS loaded and running. What do I need to do to get xp_sendmail to work? The docs on this command are sparse and hard to follow for configuring. Thanks,
Leo T. Smith
-
Hello, I am having trouble sending an email from a stored procedure in MS-SQL 2005. Here is the error: xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. The box is a server and does not have Outlook loaded but does have "Database Mail" loaded along with the SMTP mail for IIS loaded and running. What do I need to do to get xp_sendmail to work? The docs on this command are sparse and hard to follow for configuring. Thanks,
Leo T. Smith
I'm not familiar using xp_sendmail- i only tried to send mails by using sp_send_dbmail. Did you try out this function? maybe you could use that one!