I would like to know if it is possible to verify that an SSRS subscription that was set up to send an email sent it to a real address. That is, if I put in an email address that is not valid, can I find out that an undeliverable message was sent back from the destination server?
I tested this with an email address that does return an undeliverable message when I emailed to it from Outlook. After the subscription ran, its status simply said
Mail sent to email@example.com.
OUR SOLUTION: We set up a shared Outlook account with a generic email address. Those of us who have access to create subscriptions have access to this email account. We then modified the
RSReportServer.config file on the ReportServer to send emails from this new generic address. Now, any time a subscription is set up to send to an incorrect email address, we can see the delivery failure in the shared Outlook inbox. Woo hoo!