Email worksheet (attached as PDF and embedded in email)

Hi,
I am trying to upload a page in a spreadsheet to an email.
I have multiple graphs at the top, followed by a filtered list at the bottom.
I want to add the whole thing (graphs and filtered list) as a PDF (currently getting graphs and filter headings, no list below).
I also want to add the Graphs as images and the list below embedded in the email (currently get 1 graph, and headings, no list).
Still new to this - sorry about the messy code !

Please Login or Register  to view this content.

I have completely re-written the code and have the results I want.
Now copy the range of graphs and paste as image.
2 minor roadbumps that would be great if someone could help:
1) Image attaches fine, but has a white gap at the bottom (bottom of chart page). Cannot figure out how to crop this away
2) All cells format correctly when creating temp workbook, but when inserting into email the last 3 headings merge into one cell, and all the data below follows the same

Attachment 642666

Please Login or Register  to view this content.