We would like to have an Alert sent to us how ever on a daily basis about agreements expiring

We would like to add a Pop Up alert when we open a customers file either making and appointment or work order or just opening a customer file we would like a alert like a past due alert for a pending Estimate as well