Copy and Paste Table into String in HTML format

I want the same affect as copy a table and pasting into the email.

So i guess i need to copy a range and save as html in a string.

It seems like it would be simple since its just copy and paste into the email, but i've been unable to find anyting on it.

TIA

Hello Jay59,

You don't mention which email client you are using. This can be done using Outlook, but not as simply as you described. The other thing to remember about sending HTML email is, the recipient's email must also have HTML capability. If not, your HTML won't be displayed. If you are using Outlook, let me know and I'll post some code for you.

Sincerely,
Leith Ross

i couldn't find a way to due it thru thunderbird and I didn't want to use outlook.

After searching I found CDO.

I'll post it for others to use when I clean it up.

Thanks for the response.