Send an automated Email

Question

Hi All,

I want to create a macro, where an automated Email will be sent to the person against whose name the leaves have been applied.

e.g. If the person sends a request to apply leave for 2nd March 2018 (Highlighted in Red), and the slots are already full. The person against whose name leaves have been applied the latest should get an email notification stating that the slots are full for 2nd March 2018, kindly change your leaves.

This is how my excel looks like
A B C D E F
Name Dates
28-Feb-18 1-Mar-18 2-Mar-18 3-Mar-18 4-Mar-18
Email Address P P P P P
Email Address P P Leave P P
Email Address P P P P P
Email Address Leave Leave Leave Leave Leave
Email Address Leave Leave Leave Leave Leave
Email Address P P P P P
Leaves Applied 2 P 3 2 2