Hi
Kindly if somebody could help me on this
I have a Excel table as follows
<tbody>
</tbody>
I would like Excel to
Would be of great help if somebody could guide
Thanking you
Kindly if somebody could help me on this
I have a Excel table as follows
<tbody> </tbody>
<tbody> </tbody> |
<tbody>
</tbody>
I would like Excel to
- Send email to the contact as reminders of return
- If less than 3 days send an email (on MS Outlook) to abc@gmail.com
- Copy column A1 & A2 -> F1 &F2
- There should be options Will report to work tomorrow or Will report to work in 2 days time for the receiver to choose
- Which when one of the options clicked then it should revert to Excel stating 1st Reminder send and acknowledged
- If over 3 days and less than 5 days send an email (on MS Outlook) to xyz@gmail.com
- Copy column A1 & A4 -> F1 &F4
- There should be options Will report to work tomorrow or Will report to work in 2 days time for the receiver to choose
- Which when one of the options clicked then it should revert to Excel stating 2nd 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
- Copy column A1 & A3 -> F1 & F3
- This is your 3rd reminder, please confirm you will Will report to work tomorrow or Will report to work in 2 days time for the receiver to choose
- Which when one of the options clicked then it should revert to Excel stating 3rd Reminder and Escalated to Supervisor
- 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