• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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


New Member
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