Email body contains cells from row with cell that triggers the email

I tried searching for this but I am new to vba and the terminology. I've cobbled up the coding from other peoples codes to create mine. Everything was working fine until i decided to get cute and add a body to the email.

Heres what I am trying to do...

If column F is > 7, an email is to be sent to the supervisor stating so. I was the body of the email to contain info from a few other cells in the same row as the cell that triggered the email. You will probably look at the coding and laugh at me cuz it is probably something easy...I'm sure you will see what I am trying to do just by looking at it. Also, while we are at it, vbNewLine doesn't seem to work in the email body...what's up with that?

Here is my code and thanks a ton in advance!

Please Login or Register  to view this content.

no takers?