Thanks @jason , this is LEGENDARY!
I’ve played around a bit and am not wondering whether it’s at all possible to also rename the file attachment that is produced by the reporting server.
I’ve searched through the ReportServer tables and haven’t found anything obvious just yet.
For an emailed report, the filename is merely that of the ReportName within SSRS, so does that mean if we could Update the ReportName before running JAson's StoredProc, that the attached filename would be changed too...?
Would you perhaps have any pointers on where one could update the filename that is produced?
#EDIT: I tried renaming the [NAME] column in the dbo.CATALOG, however this had no bearing on filename which ws still attached to the email with the original Report Name.