Email multiple people based on response

I have an issue where I will make a meeting in Outlook for 80+ people and some people respond but don't send a reply so when I look in the tracking tab for the meeting I get a bunch of responses that say none because of this and it causes issues with accurate head count for meetings and catering for food.

I want to be able to email everyone in column C that has None as the response excluding the meeting organizer since they will always be none. I also need column A to edited over the course of this. Since I use outlook's GAL it shows each user as First Last for their name like John Doe for example. Everyone in the company has [email protected] as the email so I'm hoping it's possible for someone to be able to turn First Last into that email and then email the list based off if they didn't respond. I attached a sample workbook, I hope this all makes sense