Islam Mamdouh Ali
New Member
- Joined
- Feb 25, 2017
- Messages
- 20
- Office Version
- 365
- 2021
- Platform
- Windows
Hi Dears,
I Need your assistance as I have an insurance policies excel register containing each policy basic information and it also contains the inception and expiry date of the policies also I have a column tells me the remaining days to renew each policy(Renewal column).
what I need is that when I open the mentioned excel register the excel check the (renewal column) and send me an email alert to inform me that there is a policy about to be renewed,that is before 10 days of the renewal date.
for more clarification you will find the sheet via the following link which I have explained the requested :
https://ufile.io/yvl9o
Appreciate receiving your prompt feedback.
Thanks in advance.
Islam Mamdouh-Egypt
I Need your assistance as I have an insurance policies excel register containing each policy basic information and it also contains the inception and expiry date of the policies also I have a column tells me the remaining days to renew each policy(Renewal column).
what I need is that when I open the mentioned excel register the excel check the (renewal column) and send me an email alert to inform me that there is a policy about to be renewed,that is before 10 days of the renewal date.
for more clarification you will find the sheet via the following link which I have explained the requested :
https://ufile.io/yvl9o
Appreciate receiving your prompt feedback.
Thanks in advance.
Islam Mamdouh-Egypt