Hello,

I would like to automate time consuming process of sending statements.

Is it possible to create a macro which would:

0.PNG

1) filter pivot by provider no1 (row label)

1.PNG
2) open blank email & copy data with appropriate email address (from email list / some providers have 2 email addresses)
2.PNG

3) send
4) repeats same process for all providers

Thank you for your help / ideas

Kind regards,
Jakub