Log In
Register
Home
New Member
April 30, 2022
Offline
I just read the article "Automating and Emailing Pivot Table Reports" and it awesome.
However, I need help on following
1. I need to add filtered data from pivot as table to the email body instead of attachment
2. add cc, subject and text in the body from cell range
3. and add a fixed range table on top of pivot table after text
4. and no action if it filter category is blank,
I have attached sample file
Really appreciate your support.
The following users say thank you to aimy m for this useful post:
Riny van EekelenJuly 13, 2021
Offline
When it comes to emailing from xl - I've never had an issue that Ron wouldn't have an answer for: https://www.rondebruin.nl/win/.....ction1.htm
As for other points you've listed - well, they all can be done via vba and are relatively easy to implement but you'll need to provide a bit more details to get a quicker and more targeted responses.
New Member
April 30, 2022
Offline
I just need same code as this https://www.myonlinetraininghu.....le-reports
but instead of adding pivot table as attachment I want add in the email body as html (not as picture)
Thanks
1 Guest(s)
