title: Send email based on drop down selection
body: <p>I have a list of three option values in a table. 'Approved' 'Pending' and 'Disapproved'. When a user selects an option I want a different email to be send to that person. I have another field name 'Email Address' on the same row (next to the drop down box). I was thinking I could capture the specific email address in the cell and send an email based on the selection. Would this be achieved by using an If else statement for each option value and then sending a specific  mailto to the email address in the table? or would it be better to have a submit button which sends the email once the choices have been selected? </p>