Send a outlook email through the excel sheet

Dear Experts,
I need to send a email on daily basis through the excel sheet in the attached format.I made some codes, its not working.Anyone please review and amend my code.
If column K = yes, then I need send a mail with attachment.
To address in Column G
CC in Column H
Subject in Column I and
attachment path in column J
once email was send and i need the sending date in column L