Hi guys,
I have never written a macro before, only recorded them. By recording the macro I can only get the sheet to save as PDF not attach to email. What i'm trying to do is: I have a sheet called "Exchange Sheet". I need a macro that will safe this sheet to my desktop as a PDF (with the same name "Exchange sheet") then attach it to an outlook email. I would then just manually enter email address and email text.

Any help would be greatly appreciated.