How to send email from a table in SQL Server
Create a new table named System Generated Email in SQL Server Database: CREATE TABLE [dbo].[B$System Generated Email]( [No] [int] NOT NULL, [To Address] [varchar](250) NOT NULL, [From Address] [varchar](100) NOT NULL, [From Address Title] [varchar](250) NOT NULL, [CC Address] [varchar](250) NOT NULL, [Email Subject] [varchar](MAX) NOT NULL, [Email Body] [varchar](MAX) NOT NULL, [Sent] [tinyint] NOT NULL, [Email Sending Date] [datetime] NOT NULL, [Email Sending Time] [datetime] NOT NULL, CONSTRAINT suppliers_pk PRIMARY KEY (No) ) This table will contains all system generated emails. Now we need to write a SQL Procedure which will create emails from System Generated Email Table and send through the SQL email profile. Email profile can be found in Database Mail option: SQL code for sending Email: USE msdb GO DECLARE @email_id varchar(250), @from_mail varchar(250), @c...