How can I auto email updated fields from excel using VBA?

Guru's,

I have a spreadsheet that is updated daily, the columns are always the same (A through E), but the rows change each day. I had code that would put just the updated rows in an email and send it. The problem was, it only sends the text from the cells, not the formatting. While trying to figure it out, I messed the code up so now it only sends a blank email, please see code below.

Please Login or Register  to view this content.

Where did I screw up? Can the formatting be sent to the email as well? The formatting is actually a table, see attached for a sample
Sample EOSR for Excel Forum.xlsx
Thank you all for any help/advice

OK, one more try. I thought after being on here for a while and learning a thing or 3 that I might have been able to figure this one out myself, but, it's not happening. I am still having the above issue when the email is sent.
This is what is being put in the body of the email...

This Day This Person N/A2 ON 6A CM Air This Work
That Day That Person S07 ON 13B PM Electrical That Work
yesterday those people SO on 44A PM Hydraulic More work

This is how I want it to look in the body of email, which is just as it is on the excel spreadsheet (See attached)
Auto email.xlsx

If I copy and paste it manually to the email it does it correctly. Is my best option to use copy and paste in my VBA code?

Solved per this thread
http://www.excelforum.com/excel-prog...-with-vba.html
Thank you Gregor Y