I will have a table which contains the Student Name, ID#, Email Address, and Loan Amount. The report (to be emailed) will consist of a lot of static text with the name ,ID# and Loan Amount getting merged in at specific points in the Text (i.e. like a Word mailmerge document). This table will "generally" be 10-50 rows. Been searching but not finding anything. What I need is for each row in my table, I need to send the report to the Email Address in the that row with the ID# and Loan Amount filled in for that row. Example: Table has 3 rows John Smith 123456 John.smith@yahoo.com 212.12 Julie Joones 987654 julie.joones@gmail.com 1000.00 Willy George 004545 willy.george@nyu.edu 2000.00 So how can I have 3 separate letters sent with the id# and Loan Amount for each for that ID#? Or can I in SSRS? I've worked wih data driven subscriptions but will it send the correct letter to the correct address with the ID#, Name and Amount in the email for that learner? as in: Email sent to John.smith@yahoo.com with the name, id and amount for him Email sent to Julie.Joones@gmail.com with the name, ID and Amt for her Email sent to willy.george@nyu.edu with the name, ID, Amount for him

Hi CincyMark, From your scenario, you would like to send the report to different person with their own information using data driven subscription, right? Please connect if me if my understanding is wrong. Of course, we can achieve this using data driven subscription, please take the following steps as a reference. Step one: Create a report with ID# as parameter Step two: Create a data driven subscription on the report. 1. Select Email from Specify how recipients are notified drop-down list. 2. Configure the subscription query, type in the text box: Select * from Table. Click the Validate button to check if the query validated successfully. 3. Set the Table parameters, for the parameter which you are using to filter report for different persons, select Get the value from the database option. In this case, we would choose ID#. 4. Specify a report-specify schedule for the report depending on your needs. After you completer these steps above, you will found the report is send to different report to different person according to the ID# parameter. For more details about the topic, please refer to the following article. Setting Parameters in a Subscription: http://msdn.microsoft.com/en-us/library/ms157306(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Eileen