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 -
https://docs.google.com/spreadsheets/d/1Qu4b8dHpX_5fRU8l_m4uwslr7YKJ6XikSDz37GxN0TQ/edit#gid=1669527768");
}
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)