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.
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/section1.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.
I just need same code as this https://www.myonlinetraininghub.com/automating-emailing-pivot-table-reports
but instead of adding pivot table as attachment I want add in the email body as html (not as picture)
Thanks
You should be able to use Ron's RangeToHTML function
