Excel selected range to be attached in Outlook email as formatted text via VBA

[naveeddil]

Hey Geeks at Chandoo,

I need some VBA coding to send a range of data as below snapshot from sheet1 as Email body instead of PDF.


The email address is already written on active Sheet1 in cell M8.
The Range to be selected is having two portions.
1. A1:O9 is fixed and will be with every mail.
2. A10:O3000 is based on a filter where Column J = 1


Below is screenshot and attached sheet.

View attachment 80345