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,
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,