Sending data to a mail recipeant

[drag-driver]

My problem is such. I am testing data row by row if the data satisfies my conditions i want to send this row of data(only) to a mail, after it is gone true all the data i want to be able to send out the mail, which should contain all the rows which satisfied the criteria.

 

[lenze]

Why not use an Advanced filter to move the rows that meet yout criteria to a new sheet and send that sheet?