title: How to send automated emails?
body: <p>I am working in C# and Sql server. I have a table Email that contains fields from, to, subject, body, CC, BCC etc. When something happens in it saves the notification. I want to send the mail notification that newly inserted in Email table automatically. Is there is a way in SQL Server??? Which send emails automatically and deletes the record from the table. OR what is the efficient way for this task (from C#code or else). </p>
  
  <p>Thanks,
  Girish</p>