Hello, please can someone help me out with a macro.
I have attached a demo sheet like the excel sheet I will be working on.
I would like a macro button to print the active sheet which I am working on to the desktop as a PDF document with a concatenated file name of the salesman and the date
Then email the PDF to the email address which is stored on the active sheet in cell C1 with a subject of Commission Statement.
All the Salesman* sheets will have the macro button.
We use Excel 2010 and Outlook 2010
Anyone able to help me with this, any more information required please let me know.