Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scprideandms
Starting Member
2 Posts |
 Posted - 2011-05-04 : 14:39:45
|
| 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 rowsJohn Smith 123456 John.smith@yahoo.com 212.12Julie Joones 987654 julie.joones@gmail.com 1000.00Willy George 004545 willy.george@nyu.edu 2000.00So 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 himEmail sent to Julie.Joones@gmail.com with the name, ID and Amt for herEmail sent to willy.george@nyu.edu with the name, ID, Amount for him |
|
|
|
|
|
Data Driven Subscription with Multiple Emails