Macro - xlsm to pdf with specific file name & file path - attach to email

Hi everyone, I have found a few examples online however my knowledge of coding is so basic I can't edit them to make it work in my scenario...
Any help would be massively appreciated! My boss has given me a tight deadline and I'm lost... I have cross posted this as I need an answer ASAP..

http://www.mrexcel.com/board/threads...email.1178068/

http://www.ozgrid.com/forum/index.ph...tach-to-email/

What I need to do

• Export current active sheet (Print Area Only) as a PDF
• Save the File with the contents of Cell I1 as the file name
• Save the file to Q:\3. PCR Reporting
• Attach the file to a new message in Outlook and display
• Leave To & CC Blank
• Subject: Cell I1 with no file format
• Body
• Hi, Test (I will fill this in)

Administrative Note:

Welcome to the forum.

You have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. I cannot do it for you, as I don't know where the cross-posts are. You will not be able to post the links without adding a couple of gaps to the URL.)

Thanks. I have added the links to your opening post.

Please share any solution you get here.