How to send email from SQL Server?

Question

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

Answer 1

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 

Answer 2

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/