Macro to email the spreadsheet

[josullivan601632]

Hello everyone

I am creating a expense sheet for my colleagues to complete and save/send electronically. Would be great if I could add a macro (assigned to a button) to send the completed sheet to my email address and if possible copy in the Director, with any attachments (like copies of receipts). I use various macros so am somewhat ok and enjoy being creative with them, but this is out of my league!

Would anyone be kind enough to help me impress my new boss

 

[josullivan601632]

Should probably mention we use outlook for our emails.

 

[Adendum]

Lol, I have the same need.Did you ever find a simple solution?