It's difficult to see what's going wrong without seeing the data. I could look into this via a screen share if required. Another way to think is add a column called Email Send Yes/No. Filter the list where email send is Yes. Also one the email is sent then update the list column to Yes.
Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up