Auto Email tabed worksheet?

S

Scamp

I have an excel file that tracks leave time. For each employee there
is a seperate tab that tracks their hours What I need to do is
automatically email each employee just their sheet. I can do it
manually by File->Send to->email from each tab but that's boaring...
What I need is a "button" I can push to send out each tab
individually.

Can anyone point towards a solution? Should I look at mail merge?
Macros, or dive right into VBA?

Thanks.
 
Top