December 21, 2015 at 10:15 am
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
[ @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
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
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