Last post Nov 19, 2014 09:41 PM by Michelle Ge - MSFT
Nov 18, 2014 01:39 AM|Kothapally|LINK
I have a requirement to send Report to Email.
Here Mail(To mail) has to go based on a result set retrieved by a query, as it will differ for every user.
Can we send this by using "sp_send_dbmail" or email subscriptions?
if Email subscriptions how can we set "To mail" dynamically from Query?
Nov 19, 2014 09:41 PM|Michelle Ge - MSFT|LINK
So far as I know, if you want to configure reports to be delivered by e-mail, you must configure the item
E-mail Settings in SQL Reporting Services Configuration Manager.
For more information about how to configure a subscription to deliver a report by e-mail, please refer to the link below to configure steps by steps:
Hope it's useful for you.