Excel tables into outlook email

I have a email template in my excel sheet, I do it this way as some of the fields is formulated and also it will be easier for users to amend the template.

For example, in my workbook, I have a sheet names "email"

In the "email" tab, I will have something like this:
--------
Hi all,

Report below shows the expenses incur in department ABC for the period of Jul'2014.

Postage 500
Travelling 4200
Printing 300
Total 5000

Thanks,
Admin
---------
Being all the bold characters are formulated to other sheets in my workbook.

So now, how can i build a vba code to copy these range of data(all these texts and formula is only in column A1:A100) from my email tab to outlook email body?

And I also found out there's a very useful button in outlook email that can convert the table pasted into text by paragraphs. How do I know what is the vba code for this?


Thanks,
Ray

Attached is just a sample file.

I just want to copy from range A1:A11 into the body of email with the formatting and tables.
Once pasted onto email, vba to use the function already in Outlook to convert the tables into text paragraphs.
sample email.xlsx

Thanks,
Ray

thanks guys
i've managed to make use of Ron De Bruin's rangetohtml code.
But I still struggle with one problem which is how to get the code to use convert to text in outlook?
convertotext.png
is there any way that i can view the codes library for outlook?

Thanks,
Ray

once I have pasted the range into email body inside outlook, is there a way to select that range in outlook?
so i can put the ConvertToText in outlook.

Hi Naveed, i'm able to do with the copying of range to mailbody.
but you see, when you do that, the contents that appear in the mailbody will be inside tables.

i'm struggling now to get the table to ConvertToText.

not sure how i can select table of what i've pasted and then use the function converttotext in mail body.