From Kelly Rion@21:1/5 to All on Fri Apr 7 08:26:00 2023
I have a button that when selected sends an email to a certain email, but I would like the Subject line and body to include whatever is entered in cell G5 + is completed. Below is the script that I currently have
function sendEmail(){
MailApp.sendEmail("Kelly@***********.com","Workorder is completed","Workorder is completed and ready to close -URL");
}