Selected Answer
Your problem isn't related to code. Therefore code can't provide a solution. Instead, your problem has its roots in worksheet design and, ultimately, logic. That is where a solution must be looked for. Coding can only start when the logic is complete and flawless and the worksheet design was adapted to accommodate it.
It seems that you envision a program which loops through all rows in your worksheet and sends emails to eligible addresses. For this the worksheet must meet two requirements.
- There must be an email address in each row.
- There must be a criterium by which to decide which row is "eligible".
It seems that you envision an email to be sent once daily. Therefore the eligibility criterion might be a date. A column must be added for that. It could be hidden. When an email is sent the current date and time is entered in that column by the macro that sends the email. And when the macro scans the list again for eligible rows it will skip those where the date is less than 24 hours in the past. Now, if that is your idea to implement then that is the question you might ask.
However, there is an even more basic gap in your logic. It seems that you envision that the code would scan the sheet continuously, sending emails when an eligible row is encountered. Don't you ever switch off your computer? Why do you need to scan continuously if you want to send emails only once in 24 hours?
At the very least, you might envision that a scan is performed at 10 am every morning and emails sent to qualifying recipients. But why so complicated? You might think of sending emails when you load the workbook. Or you might want a button: so you load Excel, open the workbook, check entries and update them, and then press the button to send emails to qualifying recipients. This too, has nothing to do with coding. The question is how you want to design your workflow.
As you see, your "question" breaks down into two areas. One is to establish a loop, as you call it, which scans all rows and sends emails to everyone. This loop doesn't exist today and it can't be created until you decide how it is to be used.
The second area would establish qualifying recipients. For this purpose the criterium column (I have suggested a date) is missing in your worksheet but, even more importantly, you are extremely vague in your definition of the rule by which eligibilty could be decided. "once an email has been sent" is vastly different from checking if one was sent within the last 24 hours. Definition and determination are decisive factors. Once you program "24 hours" you also need to fix a specific time of day when the scan is made. This topic is unrelated to programming and entirely dependent on how you wish to work.
My advice is to start at the beginning. First decide how you want to work. Then design your worksheet so that it can support your vision of the work. Make sure that the worksheet can function manually. And only then automate the process - one small step at a time.