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 |
Ranjit.ileni
Posting Yak Master
183 Posts |
Posted - 2013-02-09 : 01:49:53
|
Hi Experts,if I run one Query then I will get this result:Assume,select responsibleprovider ,emailaddress from table1responsibleprovider emailaddressaaaa, bbbbb aaaar@uphs.upenn.eduddddd, Pppp ddddp@uphs.upenn.eduif I run another query I get this result:Assume,select Count ,responsibleprovider from tablereportCount responsibleprovider 6 aaaa, bbbbb8 ddddd, Pppp I need to send this people email about the number of reports waiting for them (knowing their email address from the previous SQL):For example, contact Email will get email: You have 1 report aaaa, bbbbb will get email: You have 4 reportsI am new to Mail functionality in SQL Server , Could you please advice me , how to send an mail to repective preoviders with some text.Thanks!--Irk |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-09 : 08:24:56
|
you can also implement this in ssis using send mail task. Just add a connection to your email server and it will sent the mail.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|