Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 03 May 2018
  0 Replies
  3.5K Visits
0
Votes
Undo
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 2 3 2 2
There are no replies made for this post yet.