Dynamic Email with Pivot as body

[frossen]

Hello,

Im trying to make a VBA macro there will send a dynamic range based on the recipient.
The recipient mail should be text, and there is no need for filtering.

The data is presented like the picture below.

Recipient AHJ needs an email with the following table:

Recipient LFE:

The recipient email will be columnA@xyz.com.


I hope there is someone who can help me.

Thanks