Draft email create from vba, body to contain worksheet

Hi, I'm designing a quote system whereby data is entered into a worksheet (QuoteGenerator), when the create quote button is selected a separate worksheet (QuoteTemplate) is populated and a pdf file created. All works well. What I'd like to do is to create a draft email that has the body containing the QuoteTemplate worksheet including company image, and to also attach the pdf. I've managed to get a draft email created but can't get the worksheet content included. Attached is the QuoteTemplate worksheet, some values are undefined but that's because I've removed some of the source info. It's the entire sheet contents I'd like including in the body of the email. Any help appreciated.

Apologies, excel for office 365 mso (16.0.12624.20348) 32-bit

This forum never fails to impress. It works perfectly in outlook. Just one observation: I've been using a yahoo account for donkey's years which I run in Chrome or on my phone using the yahoo app. The body contents don't display properly in the yahoo apps. As part of my process I create a pdf of the quote and am going to attach it to every email so am of a mind to add a note at the top of each mail to advise to open up the pdf if the contents don't display properly. If anyone has any suggestions to get round this please advise. I've also just tried accessing from an iphone and there's a big gap at the top which makes it look like there's no content, scroll down and the details are there. There's an attachment showing but no pdf I can click on whereas in a different email with a pdf it's a clickable file. If anyone's come across this all help appreciated. Just using outlook is well impressive so thanks all.