Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Program a button to copy a pivot table and then email | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
Why size of email with pivot table is so big? | Excel Discussion (Misc queries) | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel |