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.
| Author |
Topic |
|
harrisw48
Starting Member
34 Posts |
 Posted - 2008-02-08 : 10:26:16
|
| Im trying to create some code that sends an emailCode Below:EXEC master.dbo.xp_sendmail @recipients = 'name', @subject = 'The results are '+@results, @message = 'this is the message'I cant get the @subject but to work. It keeps complaining about the + |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-08 : 13:29:56
|
| use like this then:-SET @results='The results are '+@resultsEXEC master.dbo.xp_sendmail @recipients = 'name',@subject = @results,@message = 'this is the message' |
 |
|
|
|
|
|
Using XP_SENDMAIL