Table from excel to email body

[dantheram]

i am trying to simply paste a some values from a pivot table to an email body via VBA, i have deployed Ron DeBruin's methodology - RangetoHTML but my organisations blocks the file type this method uses.

is there an alternative?

Many thanks