VBA Save specific sheet to PDF with name build from cell values, e-mail afterwards

[pieter89]

Hi all,

I have searched the forum to find a solution but did not come across the right solution (I think).
Could you please help me with the following?

I am searching for a VBA code that saves not the activesheet but an specific sheet (Book-out formulier intern) to PDF.
The file name should be based on a combination of 2 cell values and a fixed text (Book-out, B4 - D12) (cell vallues not of the active sheet but from the specific sheet (Book-out formulier intern).
The file should always be saved to the same (fixed) folder (C:\Users\piete\OneDrive\Book-outs\.

After saving the file should be attached to an e-mail (via outlook) and the subject should be the file name.
TO should be filled in via outlook, CC should be 3 fixed e-mail adresses.

Kind regards,

 

[pieter89]

To activate the macro I will use an button on the input sheet.