• Google Sheets Subject line to be a cell value

    From Kelly Rion@21:1/5 to All on Fri Apr 7 08:23:04 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 -https://docs.google.com/spreadsheets/d/1Qu4b8dHpX_5fRU8l_m4uwslr7YKJ6XikSDz37GxN0TQ/edit#gid=1669527768");

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