Email from Excel Pivot table
 

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

Email from Excel Pivot table
 

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...
--
HTH...

Jim Thomlinson


"Jason" wrote:

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