Auto Email tabed worksheet?

  • Thread starter Thread starter Scamp
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate hours worked from hours on break, lunch, etc.? 1
Lookup on worksheet 1
Email Merge 1
Can I create a shortcut from a cell on one tab to another tab? 2
Best way to pull data from several different sheets into a summary sheet 2
Hyperlinks and Email Attachments 2
How do I email individual tabs in a workbook? 1
Blocking/Disabling selected worksheet 1

Back
Top