In my worksheet, I have a drop-down list of names in J11. Hidden in the worksheet with the names for the drop-down is the email address for each name in an adjacent cell (e.g. A1="Name1"; B1="Name1email"). When "Name1" is selected from the drop-down list, I need "Name1email" to be inserted in another cell. I will then use "Name1email" in my OutMail subroutine to email the sheet.
How can I do this?
Bookmarks