Send email to multiple receipants

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  November 29, 2017 at 1:00 am

  #326524

  Hello guys,

  I am having a table in my database where I am storing details of employee and manager as below.
  Empname ,ManagerName, ManagerEmail.

  I want to send Empnames to ManagerEmail. Here I want to send single mail along with all reported names as below

  Email Body is as below:
  The following employees are reporting you, Please acknowledged them.

  1.  Employee 1
  2.  Employee 2
  3.  Employee 3

  How can i implement this?

  Thanks,
  Abhas.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 29, 2017 at 1:16 am

  #1969837

  Not much to go on.

  You got your sample data, scripts and your mail routine?

  But wouldn't be to tricky to write a query to build up the @body value and pass it into sp_send_dbmail