Send personalized pivot data to multiple recipients

[Ragnarrok19]

Hi

I have a requirement where I need to create a metrics pivot for my respective employees & send to them on a weekly basis. I don't mind creating the pivot or even arranging it in a good format, but I have to go through multiple steps like setting up the EmpID in Pivot filter to populate it's details, copy it, paste in Outlook & Send & come again repeat it for 100 more.

Is there a way I can automate this ? Like something that runs & changes the Pivot filter selection for all my employees one by one & also sends them emails ?

[maniacb]

It would help if you could provide a sample sheet as per the yellow banner above for us to provide detailed assistance. Make sure the sample you provide is desensitized.