How do I email individual tabs in a workbook?

B

Bean Counter

I have one file for commissions / sales for each of our 30 sales reps. Each
rep has their own tab with their information in it. Every month I go through
and update the information, print them out and send them to each individual
rep. Each rep only receiving their own information of course.

I would love to be able to save time by emailing the reports instead of
printing and sending. I would also like to keep all of this information in
one file instead of having 30 separate files (one separate file for each
rep).

Is there a way to email an individual tab without sending the whole file?
If I could just email each tab to each rep I could save a ton of time!
 

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

Split up spreadsheet by sales rep 1
Auto Merge text from multiple sources 0
loop through code and refernce text file for info 1
Lookup to create a table of data in terms of selection 1
Create a new workbook for all Unique values and new work sheets tothat new workboks 0
Combining three files when middle file has sections with endnotes 2
Possible to Combine reports to's to a single box? 0
sumif with four criteria??? 8

Top