Post reply

SSRS Report emailing base on email address on report

  • April 29, 2011 at 11:41 am

    #250129

    Hi I was wondering if it's possible to have a report run on a scheduled bases and email the report base on the email address on the report

    For example, I've been asked if it's possible to run a report with a batch of membership renewals. And have each individual renewal be emailed to the matching member using the email address on that renewal (there will be many renewals but each member in the batch will only get one renewal).

    Thanks

  • April 29, 2011 at 2:03 pm

    #1317951

    You can do that with a data driven report where the subscription information itself (report parameters, as well as subscription parameters of To, CC, BCC, etc.) can be defined in the query.

    Build your report. Then build a new data driven subscription and several steps into the process you will have the opportunity to write a query for the data you need for the distribution list, etc.

Viewing 2 posts - 1 through 1 (of 1 total)

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