Right, managed to get it all working, heres the code for those who are interested:
Aim - Generate a new report, save it to a temporary directory, automatically attach it to an email (by passing the path into email object)
Code -
If anyone else happens to stumble across this code and fancies using it, just beware that every time you create a new document using this code, it will overwrite the previous file. It is best to generate a unique filename but for our software our client wanted a specified filename. Luckily we only have 1 user of this section of the system so it wont be an issue for us.