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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-11 : 08:18:41
|
| Raajiv writes "Hi,I am Trying to Send Mails Through SQL Server. It is Working Perfectly Alright. The Only Problem With It Is That The Recipient Is Not Getting Subject In The Mails.The Query Which I Execute Goes Like Thisxp_sendmail @recipients = 'shekhar.thanvi@gmail.com', @message = 'Below Mentioned Files Are', @copy_recipients ='dipesh.patel@gmail.com', @subject='Reminder', @query='select * from MyTable'Pls Suggest Me The Way Out Of This I Will Be ThankFul To U." |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-11 : 08:56:27
|
| Try leaving the @subject parameter out and then you should get the default subject (something like "SQL Server Message" I think)If that works then there is something wrong with @subject='Reminder',assuming that that is not an exact copy of the code you are using ... maybe it is a variable which is becoming NULL??Kristen |
 |
|
|
|
|
|
Not Getting Subject