Send E-Mail to list of individuals defined in a particular Range

Hello Friends,

Need your help to accomplish subjected query!

Please open the attached file (normally it saved in a network path); this is a standard template which we are using it for some approval process.

Column L will be updated by some corporate person (based on input from some external sources) who is sitting some other plant.

Daily I need to send an update to a list of people as below & I want this to happen just by press “Send Request” button:-

To Recipient: - VBA has to look the Mail ID from E-Mail List worksheet and the Range is C3:C12.

Cc Recipient: - VBA has to look the Mail ID from E-Mail List worksheet and the Range is D3:D12.

Subject of the E-Mail:- “Serial Number 2,4,6,7,8,9,11,12,13,14,15,16 is Waiting for the Approval” (VBA has to pick the serial number based on code updated in Column N i.e. Zero)

Content of the E-Mail:- Excel File where it is saved, that Network path link should appear

Signature of the E-Mail: - Let this be a default signature which is defined in my outlook.

Immediate suggestion is really appreciated!

Thanks & Regards,
Rajeshkumar R