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 - 2002-12-06 : 09:05:48
|
| Acylo writes "Troops,I am a very beginner in SQL Server and Databases.I have a question that would seem very simple, but I don't know how to.Here: I have a table let's say MyTable1 with 4 columns: MyTable1 EmpID EmpName Phone Email ------ -------- ------ ------ 123 Guru Guy 5674651 emp1@somwhere.com 126 Guru Girl 5678958 emp2@somwhere.comI need to write a stored Procedure that would send an email to a particular employee let's say to emp1@somwhere.com. How do I do that? Plase take to the simplest level for me to understand.Where do I put the email message and stuff?Thanks a million in advance!Peace,Acylo" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-06 : 11:46:12
|
| Have a look at xp_sendmail in BOL, plus thes linksEmail using SQL MailSQL Mail[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321183[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293[/url][url]http://www.allisonmitchell.com/Articles/mail.htm[/url]Email without SQL Mail[url]http://sqldev.net/xp/xpsmtp.htm[/url][url]http://www.sqlteam.com/item.asp?ItemID=5003[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;q312839[/url]HTHJasper Smith |
 |
|
|
|
|
|
Sending an email from Microsoft SQL Server via a sp