Hi,
I am wondering if there is a way to copy and paste a union of ranges into the email body of an outlook message.

I want to send a row header, and different data sets to different lists of people. For instance

Row Header and
Rows H2:AD2 to H9:AD9

And Row Header with Rows H10:AD10 and H:12 to AD:12 and so on. This message would be sent to multiple emai receipents using Outlook.
I have tried a bunch of different ways including setting up a Union but I still can't seem to get it.

Any assistance would be great!