Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Sending a query to Sql Mail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-25 : 22:10:56
Richard writes "Hi ive setup my sql mail successfuly and Have got the xp_sendmail sp to send a query result to an email address.

The problem im having is sending a query request to sql mail via email. Am I doing it right ? i tried putting the query in the subject and the message body and whenver i run sp_processmail i get an error,

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
Queries processed: 0.

Any ideas ?

Thanks

Richard"
   

- Advertisement -