I am looking to assign vba code to a command button which will do the following:

1) Print worksheet €œQuote€� and worksheet €œSheet1€� to my default printer.
2) Save worksheet €œQuote€� as a PDF to the folder €œR:\emailed quotes\€�, giving it a file name taken from cell: Sheets("Quote").Range("M1").

If possible, I would also like to then attach that pdf to a new email. I am using Outlook and Excel 2010.

Thanks in advance, I hope someone sees this as possible, I havent had much luck so far.

Thanks, Paul
-accidentally posted this to microsoft.public.mac.office.excel earlier.