while loop to check value condition and send email

Hi all,
i have been working on this project for week and couldn't find a way and i hope you can help me please.

i have excel sheet where has equipment with number of running days and if the cell reach certain value, it should send email to the responsible employee. i have about 25 equipments and the while loop has to check every row and check the running days if is equal or less than 60 days, it should send email automatically.

i hope it's clear to understand and i have to submit this in 2 days.

Anyone help me please. i'm new in VBA