Send Simple Leave Notification email to User

Guna13

Board Regular
Joined
Nov 22, 2019
Messages
70
Office Version
  1. 365
Platform
  1. Windows
Hi all,
Need support to send an email "On Current Date" to the respective user reminding him\her to take a break for work/life balance. There is a Report Download From HR Portal. All users have applied for their leave for the next three months well in advance.

The object of this scenario - In case they forget, we need to notify them "On the same" day. To take the Leave. ( If criteria are met (Only Earn Leave & Current Date).

Sample file attached, I Don't have a idea, how to start and where to start here.

Only the rows and columns have been increased, the format is standard. If there is a solution code, I will schedule that macro in the task schedule for the daily morning.

Kindly help me.

Send Simple Notification email to User to take Leave
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Kindly help me to update this request. thanks
 
Upvote 0

Forum statistics

Threads
1,224,816
Messages
6,181,138
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top