When I will Check The Check Box In Column U Open Mail Id From Column D
function onEdit(event){ if ([event.range.getColumn(), event.range.getRow()].join(',') == 'U,14') { var email = event.source.getActiveSheet().getRange('D14').getValue(); MailApp.sendEmail(email, '', ''); } }