Loading

How to send email from SQL Server?

Purvesh Sangani

9y930

How can I send an email using T-SQL but email address is stored in a table? I want to loop through the table and be able to send email. I cannot find a good example of doing this so far..

Thanks for your help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth9y ago
Hi,

Try the microsoft docs code :

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql

Other Reference :

https://www.emailarchitect.net/easendmail/kb/sql.aspx?cat=0

http://www.c-sharpcorner.com/UploadFile/ee01e6/how-to-send-mail-by-using-sql-server-part-2/
0
Ankit Sharma9y ago
Hi Purvesh,

please refer to these links

https://www.codeproject.com/tips/846204/how-to-send-mail-using-sql-server-part

https://stackoverflow.com/questions/13300881/how-to-send-email-from-sql-server

you can write a SP to iterate through table using cursor, use this link

https://stackoverflow.com/a/20662486
+1