title: Is it possible to send a variable number of emails using SSRS subscription?
body: <p>I've only ever managed to setup a fixed number of SSRS subscriptions, each corresponding to 1 email, but now I want to be able to send out x emails with different contents, where x is a variable that can be queried out from the DB along with the corresponding content. The template across all these emails, however, needs to be the same. </p>
  
  <p>For example: I can query the number of meetings scheduled for today - which will vary for different days - and then send out an email at the start of the day for each of those meetings, with the subject line as the title of the meeting and the email body or the 'report' showing the meeting agenda. </p>
  
  <p>Is this something I can achieve using reporting services?</p>
  
  <p>I was able to find a solution involving SSIS that allows one to send out emails to a variable number of recipients, but I was wondering if there's another way out:</p>
  
  <p>Here's that solution if anyone's interested:
  <a href="https://technet.microsoft.com/en-us/library/ff793463" rel="nofollow noreferrer">https://technet.microsoft.com/en-us/library/ff793463</a> </p>
  
  <p>Thanks in advance!</p>