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

Want to kickstart your project?Use the new AI Studio to create your code