Post reply

Database mail configuration to send an email to multiple recepients

  • 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

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply