how to loop through each row in my SQL database and send emails?

Hello,
I am trying to loop through all the list of customers that are saved in my MS SQL table, check on something, then if it is valid, I want to get their first and last name and email address to send them an email. I am not sure how I should do this, how can I do a loop for that? I have all the sql stored procedures ready

...