How to email sheet to names selected in sheet

Hello:

I have attached the sample file that I am working on. I am trying to email the names in the signed by and professional assistance rows. The sheet that needs to be emailed is the active sheet (Sheet 1). The names and email addresses are listed in Sheet 2. Is there a way to email only the names selected in the dropdown box in those two rows using outlook 2007/2010?

Thanks so much(file attached)