VBA to send emails with different attachments to each seperate email

Hello,

I am looking for a VBA that can automatically send emails to many different recipients, each with a different attachment based on the range associated with the email address.

For example, I have a range in A1:F30, with an email address in H1, with a different range in A32:F62, with a different email address in H32, and so on. This can go on for 100-600 ranges, or 30 rows x 600 ranges =18000+ rows, depending on the data.

I need the vba to send each range to the email address to the right of the range in column H.

I have a file attached, that shows an example format of the data for 3 ranges. Again, this needs to continue for a possible 600 ranges.

In the file, there is a VBA that does exactly what I need, except that it displays each range in the body of the email. The only change is that I need the range as an attachment for each email. This one change is what I am looking for.

Please do not direct me to Ron De Bruin's website as I have been there many times.

Please help.Test Sample.xlsm