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 |
|
GenerationWithoutName
Starting Member
26 Posts |
 Posted - 2002-12-26 : 13:03:32
|
| I want to getting my email from SP. Can i do that such thing ??? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2002-12-26 : 14:00:12
|
| Yes, in BOL, check out xp_sendmail, you can call this from your stored procedure provided you have SQL Mail set up. Here's an exampleExec master.dbo.xp_sendmail @recipients='mfemenel', @query='select * from northwind.dbo.customers', @subject='Your subject line here', @message='Here is the list you requested', @attach_results ='TRUE', @width =750Mike"oh, that monkey is going to pay" |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-26 : 18:53:21
|
| If you want to read email look intoxp_readmail |
|
|
|
|
|
|
getting email