Hi all
I'm using a macro to compile an email. I have used this macro before on some other projects but now I need to make some adjustments and I'm struggling a little bit.
The main adjustments that I'm trying to achieve are:- Instead copying entire sheet and attach it to the email I only want to copy section of it (named range "Charts_breakdown").
- I would also like the macro to copy and rename a PDF file (Statistics.ppt - this file will be open before launching any macro). Macro should rename it as per value of "emailRenamePDFattachment", attach it to the email and kill the Statistics.ppt without saving it.
I have made some notes on the code. Example spreadsheet is attached. It has a macro button ("Compile EMAIL") to launch the current code. There is also a sheet called "Example of attached sheet" that is simulating the outcome of the sheet that should be attached to the email.
Any help would be extremely helpful.
Cheers
Bookmarks