Database mail configuration to send an email to multiple recepients

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  March 20, 2009 at 12:17 pm

  #155452

  Hi,

  We have configured database mail.In the receipients Iam able to give one person email address olny and Iam getting emails. But I want to add 3 more receipients to send email.How can we do this?

  Please tell me where can I add by seeing the attachment

  Thanks

• matt stockham

  SSCrazy Eights

  Points: 9942

  More actions

  March 20, 2009 at 2:33 pm

  #963800

  That screenshot is of the account settings. If you just want to send an email to multiple addresses then type each address on the recipient line in turn separated by semicolons, eg

  abc@x.com;def@y.com;ghi@z.com

  There was a character limit at one time, not sure if it still applies. You could also set up a group if your smtp server allows it.

• rajganesh.dba

  SSCrazy

  Points: 2538

  More actions

  March 21, 2009 at 2:26 am

  #963931

  In SQL server 2005 use sp_sendmail procedure

  @copy_receipents = '' to add mails id in CC lsit