Macro to send an email based on Value in column

Hello,

I am looking for a Macro which needs to send an email automatically. My requirement is as follows

First it needs to Sort Column I, J & K and all NO’s should come to the top of the report, after that it needs to check for Group (Column C) and send an email with entire row (Column A till Column K) and should not include if any of the columns are hidden to the email defined for that group (email tab in sample spread sheet). It needs to send single email for all the rows that has common group (as shown in Result tab of sample spread sheet) with "NO" in any of the Column I,J & K.

No. of rows are not constant and it keeps on varying. It needs to search till the last row of Group (Column C).

I appreciate all your help!!

Regards,
Humac

Bump no response!!