Multiple spreadsheet in email

New Contributor


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?


1 Reply

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