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
Add Sales Goals to Sales Report in Pivot Table 1
sumif with four criteria??? 8
loop through code and refernce text file for info 1
Formula Question 3
Lookup to create a table of data in terms of selection 1
A Complex Mail Merge Question 2
#N/A if cell contents not part of an array 5

Top