Link to home
Start Free TrialLog in
Avatar of bnrtech
bnrtech

asked on

Xp_sendmail error

Hello,

I am trying to use xp_sendmail to send out an email. Upon executing the procedure that contains the sendmail code i receive an error that says "xp_sendmail: Procedure expects parameter @user, which was not supplied." However after attempting to define the @user parameter an error stating "xp_sendmail: Invalid parameter '@user'" I believe the MS page tells me to leave the @user parameter off. How can i successfully and correctly send email from with a stored procedure using ms sql server 2005? Sample code attached
EXEC master.dbo.xp_sendmail 
    @recipients=N'emailaddress@anywhere.anything',
    @message=N'some text.'

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of bcsql
bcsql
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial