Creating a New E-mail Confirmation

This may not be possible, but wanted to post in case anyone has done this before.  

We currently run TNew, which handles e-mail confirmations perfectly for web orders and in person/phone orders.  Our Education department has tasked me with creating one just for their performances - more of an invoice than a confirmation, really.  These orders have hundreds of student tickets, so TNew doesn't like that.  They also need to show a balance.  We have created a SSRS report that they use to create a PDF and those are e-mailed manually one by one from Outlook.  

We're looking to streamline this process and send a customized e-mail confirmation in place of this PDF we make, but with all of the same info.  This might just be a customization with Tessitura, but seeing if anyone else has worked around that.  Thanks!