Email Range

The Email Range add-on makes it easy to create a snapshot of a portion of your spreadsheet to share via Gmail, directly from Google Sheets.

Formats in your sheet are retained: Cell dimensions, colours, fonts, number and date formats, plus conditional formatting are faithfully preserved to display properly in common email clients. 

You have the option to provide a custom message to introduce your embedded table to email recipients. Markdown is supported for rich formatting of your message.

If you want the raw HTML of a portion of your spreadsheet, click the Get HTML button.