Multiple spreadsheet in email

[Jolange]

Hi

I have to send around 40 emails to different people each week, in each week have to put 1 page of a spreadsheet - different for each person is there any easy way to do it. The overall objective is to share each persons sales figures with them but not with anyone else and a shared message that is the main body of the email.

I have been copy and pasting each one into each email but it takes forever and it's a brain drain boring job, any ideas?

Thanks.

[#2]

@Jolange Below post may help. You need to edit codes to adjust it for your need. You can download sample file from post.

https://techcommunity.microsoft.com/t5/excel/send-automatic-email-as-pdf-attachement-from-data-in-ex...