Hide row after email sends

Hi everyone, i found this code on the rondebruin website and I'm trying to make it work better for my application. This code works great, it sends all the rows in seperate emails, but the problem is- this email is being sent to a phone as a text message. I need it to display the body of the email on the top line of every email, right now, if it determines that it needs to send out 10 messages, they all go out individually but the position of the body of the email will move down as the macro moves down in the list, this prevents the message being seen when the text arrives because the screen is so small. So how do I hide the row that it just emailed before it goes to the next email?

Please Login or Register  to view this content.

Here's the range to html that is given by the ron debruin website. Possibly there is something that can be changed in this part of the code to alter how the body is displayed?

Please Login or Register  to view this content.

I think it's in this area of the code:

Please Login or Register  to view this content.

It looks like it's pulling the entire range into the body, but i only want it to pull in the same row that the email address is in.
In this spread sheet, the body of the message is in column A, the email address is in column B and column C refers to a "yes" or "no" which indicates if the conditions are met to send the email.

figured it out, it was displaying the blank subject lines becuase every email address has a line if it's a "yes" or a "no" since the "no" values were hidden it displayed blank, now that i have a formula to carry the email address into the cell only if conditions are met, it does not display the blank rows anymore..