Email from Excel Pivot table

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a pivot table which has lists of employees/transactions/date. I have
pretty much created an aging of sorts. I have then elected to 'show all
pages' where I now have a tab for each manager's email. Is there a way I can
email each tab to the respective managers in a seperate email?

Jason
 
You can do what you are asking to do but I would caution against it. The
reason being is that all of the source data used to create the pivot table
will be sent. The recipient could change the employee name and look at anyone
elses information. Additionally the e-mails will be rather large in size as
all of the source data is included. A better plan might be to use some code
to copy the pivot table to a new workbook and past only the values and the
formats. then just email that new workbook. Although not simple the code is
relatively straight forward. If you want to persue this idea then post back...
 
You must log in or register to reply here.

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

Pivot Table percentages 1
Pivot tables - adding dates, descriptions 1
Pivot Table 2
Pivot table wizards 2
Pivot Table Data Column Sort Excel 2007 1
Excel Pivot Table problem 8
Copying pivot table 2
Refreshing Pivot Table on a protected spreadsheet tab 1

Back
Top