Does anyone know if/how to configure scheduled emailed reports so the recipients are BCCd instead of all visible in the 'To:' field?
I know this is an available feature of Database mail, but it appears Tessi does not provide an interface for the BCC field. My best guess at this point is that I might be able to literally hack the email TO field in Tessi to close the one argument and add the BCC one, but I'm hoping someone has a better idea before I go in and try to figure that out.
I'm rather surprised that this hasn't come up before... but I found a workaround!
Database mail is called using a procedure that takes the following arguments for recipients: @recipients, @copy_recipients, and @blind_copy_recipients. Only the @recipients argument is built into report scheduling, but the text field in the Auto-Email Elements window is simply inserted wholesale into the procedure call with no input validation that I can find--in other words,
@recipients = '<recipient text box content>'
This means we can inject any of the other recipient arguments into the procedure call with the following syntax:
',@blind_copy_recipients = 'bccrecipient@example.com
... turning the full procedure call argument into
@recipients = '',@blind_copy_recipients = 'bccrecipient@example.com'
And sp_send_dbmail is totally okay with this!
So glad you posted this, nicely done!
If I may add to this, I wanted to send to a recipient and bcc another recipient. The syntax goes like this:
publicrecipient@ljp.org',@blind_copy_recipients = 'bccrecipient@ljp.org