Morning!
I have the macro below in a workbook with a number of purchase orders, to automatically turn the current sheet in to a .pdf and then email it to the supplier. It works great but there's two things I wanted to add, and I'm hoping someone here can help out.
1. Have the default out signature of the current user be in the email.
2. Save the .pdf file in the same folder as the current workbook, but in to a specific sub folder. The name of the current folder will vary constantly, but the name of the sub folder will always be 'Purchase Orders'
Hopefully this is enough information, if not, let me know.
Thanks in advance!
Bookmarks