Auto Emails from Excel (with If functions)

[Rile1]

Hi
Kindly if somebody could help me on this
I have a Excel table as follows
[TABLE="width: 709"]
<tbody>[TR]
[TD]
[TABLE="width: 709"]
<tbody>[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 793"]
<colgroup><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Department[/TD]
[TD]Reason of Absence[/TD]
[TD]Start Date[/TD]
[TD]Today's Date[/TD]
[TD]Absent Days[/TD]
[TD]Closed Date[/TD]
[TD]Status[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ABC[/TD]
[TD]Administration[/TD]
[TD]Sick Leave[/TD]
[TD]5-Aug-18[/TD]
[TD]7-Aug-18[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]DEF[/TD]
[TD]Sales[/TD]
[TD]Sick Leave[/TD]
[TD]1-Aug-18[/TD]
[TD]7-Aug-18[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]XYZ[/TD]
[TD]Finance[/TD]
[TD]Work Travel[/TD]
[TD]3-Aug-18[/TD]
[TD]7-Aug-18[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]Pending[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]JKL[/TD]
[TD]Sales[/TD]
[TD]Work Travel[/TD]
[TD="align: right"]6-Aug-18[/TD]
[TD]7-Aug-18[/TD]
[TD]1[/TD]
[TD]7-Aug-18[/TD]
[TD]Returned[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I would like Excel to

1. Send email to the contact as reminders of return

• If less than 3 days send an email (on MS Outlook) to abc@gmail.com

The email should

1. Copy column A1 & A2 -> F1 &F2
2. There should be options “Will report to work tomorrow” or “Will report to work in 2 days time” for the receiver to choose
3. Which when one of the options clicked then it should revert to Excel stating “1^st Reminder send and acknowledged”

• If over 3 days and less than 5 days send an email (on MS Outlook) to xyz@gmail.com

The email should

1. Copy column A1 & A4 -> F1 &F4
2. There should be options “Will report to work tomorrow” or “Will report to work in 2 days time” for the receiver to choose
3. Which when one of the options clicked then it should revert to Excel stating “2^nd Reminder send and acknowledged”

• If over 5 days, then send an email (on MS Outlook) to def@gmail.com and in cc 123@gmail.com

The email should

1. Copy column A1 & A3 -> F1 & F3
2. This is your 3^rd reminder, please confirm you will “Will report to work tomorrow” or “Will report to work in 2 days time” for the receiver to choose
3. Which when one of the options clicked then it should revert to Excel stating “3^rd Reminder and Escalated to Supervisor”

1. On a weekly basis email (on MS Outlook) a report stating of the people still on leave to 345@gmail.com

Would be of great help if somebody could guide

Thanking you