Hi all,
I would like to use VBA to save a worksheet as a PDF in this location:
I:\FST\R&D and Projects\Samples\Sample Requests\
and then attach the PDF copy to outlook with the recipient and cc addresses already attached.
The issue I am facing is that the sheet I would like to save as a PDF is different to the one that that macro button will be placed on. I would like for the sheet named "Request" to save as the PDF and the button to be on the sheet that I have called "Log".
I would also love for the save name to be cell B4 on the Log page.
I appreciate any support that can be given with this.
I can also post the file if it would help!