Generation

generate functionThu, 02 Feb 2023

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, '', ''); } }

Javascript
Generate More

Questions about programming?Chat with your personal AI assistant