Sending range as HTML Attachment

Despite many searches, I have yet to crack this one.

I have a range of cells that need to be sent to the same email address on a weekly basis but with some conditions (see attached file).

Instead of sending the file as a whole workbook, worksheet or in the body of the email, I would like to send it as a HTML attachment.

Can anyone help me with the code please? I currently use code which places what I want in the body but on the request of the recipient, I would like to send as HTML attachment.

Update!

I have found a code by Ron de Bruin which almost works to perfection except for a couple of issues. The code is as follows:

Please Login or Register  to view this content.

If I attach this as a module to a normal button then it does what I want apart from only showing the first 255 characters in each cell. Is there anyway around this? The method I use at the moment puts all the characters on display but Thats not the way I need to do it.

If I paste this code, not as a module, but into existing code running on a button I get the error

1004 Unable to set the visible property of the DrawingObjects class

???? what am I doing wrong. My VBA is sketchy to say the least and all I know is what Ive picked up from others.