Print multiple sheets to PDF, Email as attachment

[dngsullivan]

Hi,

I've looked at many different codes and can't get any of them to work for my particular situation.
I'm too new to VBA to understand how to combine the ones I can find.

I would like to print 2 sheets (Client Letter, Client Breakdown) to PDF.
File name to be contents of cell A1
save to Filepath C:\Users\Lenovo\Desktop\Quotes\2017 (any chance the 2017 folder can be automatically/easily updated each year or am I asking too much!?)
I would like the PDF to open for viewing

I would then like to email the pdf using outlook
email address: Client_Email (named range)
Subject: "J&R" +cell A1
Body: "Please find attached quote.
If you require any further clarification, please quote reference "A1""
(hopefully email signature will appear!)

I would like to manually press send.

Thanks heaps.

 

[dngsullivan]

this is the main link I was trying to copy the code from.
How to save a worksheet as PDF file and email it as an attachment through Outlook?