• Google Sheets Subject Line to be a cell value

    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");

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)