SSIS Design consideration with object variables
I would replace your output Recordset Destinations with OLE DB Destinations and deliver the required data into database tables.  As well as making the remaining work easier, this could also give you a far more useful Audit/History of previous runs. 

From that point I would then write SSRS reports against those tables and use SSRS subscriptions to prepare well formatted emails and deliver them.