MACRO to export to PDF and email

Hi
First off I am not great when it comes to VBA. What I am looking at doing is having a button that you will click on and it will convert the specific print area (I have 3) to a PDF and come up to email, so you can than select who you want to send it. I have a macro set up at the moment but you have to select the area and than it saves to file, I would prefer if possible that it automatically select area, convert to a PDF and come up to email.
Attached is an example of the report