excel Check name and use mailaddres
<p>I have a sheeta with the name of a person (dropdown), in a different sheetb (from where the dropdown gets the name) are the contact details. 
If in sheeta a person is selected and the user pushes the send button the mail has to be sent to that person, mailaddress in sheetb.</p>

<p>How can i get the mailaddress from sheetb with a code in the mail macro?</p>

<p>Anyone ideas?</p>

<p>Thanks in advance</p>