Post reply

sp_send_dbmail

  • December 21, 2015 at 10:15 am

    #314462

    sp_send_dbmail will only allow you to send to three recipients, @recipients, @copy_recipients and @blind_copy_recipients, but what if I'm try to send to four or more recipients, I can't use @copy_recipients or @blind_copy_recipients more than once even if I use a ";". Is there another option?

  • December 21, 2015 at 10:19 am

    #1847206

    [ @recipients = ] 'recipients'

    Is a semicolon-delimited list of e-mail addresses to send the message to

    can you tell us a little more about what you are trying to do

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • December 21, 2015 at 10:27 am

    #1847207

    If you literally mean just sending to multiple email addresses, those recipient parameters all accept semicolon-delimited lists, like so:

    @recipients='email1@someprovider;email2@someprovider;email3@someprovider;email4@someprovider',

    Cheers!

  • December 21, 2015 at 11:46 am

    #1847225

    Thanks, my ";" was in the wrong place in list.

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

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