Macro for saving sheet as PDF to desktop and attach to email

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.

.
This works on a PC .. not certain about a Mac :

Please Login or Register  to view this content.

Logit,
thanks for your reply. Its for a PC in my work (just got the Mac at home). I will give it a go in the morning when back to work. Thanks again