Google Sheets - Email Specific Range With Formatting
<p>Here is my sheet:
<a href="https://docs.google.com/spreadsheets/d/1LSI_fIidbbK9WTSqAnFLYUYpybuxRhBigKY7_l5-6cw/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1LSI_fIidbbK9WTSqAnFLYUYpybuxRhBigKY7_l5-6cw/edit?usp=sharing</a></p>

<p>I want A1:E9 emailed out when I hit the button. It sounds simple!</p>

<p>I can just copy and paste that range into gmail, and it looks exactly how I want. However I am guessing scripts won't retain the formatting? Do any of you have an idea on how to do this?</p>

<p>I guess I need HTML? But how would I create a script to do this?</p>

<p>For excel, I get it to take a screenshot and attach it to an email. However I am hoping there is a much easier way for google sheets.</p>