The recipientemail = Lookupvalue = Range("b16") is the column where the drop down list has the names of the people to choose from to send an email to.