Sending Email populated by google sheets -



Sending Email populated by google sheets -

our engineering science section has request form on google our company uses notify of projects , other issues need attending. requests assigned project lead in our weekly meeting. i'm trying write script populate email using info spreadsheet form driving notify both requester , project lead can contact each other straight instead of email in engineering science grouping updates. tried splicing 2 different codes accomplish unable find code adapt fit our goal. have listed links below codes used write have.

https://developers.google.com/apps-script/articles/sending_emails

https://www.youtube.com/watch?v=_tokh2jlqys

the code tells me "invalid email:" , highlights mailapp.sendemail, real email addresses. can help? haven't written code since high school web design. considering using form of notification in few of our other departments well. assuming version work.

function sendemails() { var sheet = spreadsheetapp.getactivesheet(); var startrow = 2; //first row of info process var numrows = 2; //number of rows process // fetch range of cells a2:l3 var datarange = sheet.getrange(startrow, 1, numrows, 12) // fetch values each row in range. var info = datarange.getvalues(); (var = 0; < data.length; ++i) { var row = data[i]; var requestername = row[1]; // sec column var emailaddr = row[2]; // 3rd column var requestspecifics = row[5]; // 6th column var projectlead = row[6]; // 7th column var projectleademail = ""; // 10th column else if (projectlead == "tom smith") {projectleademail = "tom@fakeemail.com";} else if (projectlead == "dick smith") {projectleademail = "dick@fakeemail.com";} else if (projectlead == "harry smith") {projectleademail = "harry@fakeemail.com";} else if (projectlead == "none") {projectleademail = null;} var emailsent = row[12]; // lastly column if (emailsent !=email_sent) { // prevents sending duplicates var myheader = "minor engineering science projects requests"; mailapp.sendemail({ to:emailaddr, subject:myheader body:requestername + ", \n\n + requestspecifics + " \n\nthe request submitted, listed above, has been assigned " + projectlead + ". \nplease contact person concerns. \n\nthank you, \n\nengineering", cc:projectlead]); sheet.getrange(startrow + i,12).setvalue(email_sent); // create sure cell updated right away in case script interrupted spreadsheetapp.flush(); } } }

i don't know if code above exact copy/paste of actual script if has lot of syntax errors (hopefully) corrected, please give try, should work if construction of spreadsheet right...

function sendemails() { var sheet = spreadsheetapp.getactivesheet(); var startrow = 2; //first row of info process var numrows = 2; //number of rows process // fetch range of cells a2:l3 var datarange = sheet.getrange(startrow, 1, numrows, 12) // fetch values each row in range. var info = datarange.getvalues(); (var = 0; < data.length; ++i) { var row = data[i]; var requestername = row[1]; // sec column var emailaddr = row[2]; // 3rd column var requestspecifics = row[5]; // 6th column var projectlead = row[6]; // 7th column var projectleademail = ""; // 10th column if (projectlead == "tom smith") {projectleademail = "tom@fakeemail.com";} else if (projectlead == "dick smith") {projectleademail = "dick@fakeemail.com";} else if (projectlead == "harry smith") {projectleademail = "harry@fakeemail.com";} else if (projectlead == "none") {projectleademail = null;} var emailsent = row[12]; // lastly column if (emailsent !="email_sent") { // prevents sending duplicates var myheader = "minor engineering science projects requests"; mailapp.sendemail({ to:emailaddr, subject:myheader, body:requestername + ", \n\n" + requestspecifics + " \n\nthe request you"+ "submitted, listed above, has been assigned " + projectlead + ". \nplease contact person concerns. \n\nthank you, \n\nengineering", cc:projectlead}); sheet.getrange(startrow + i,12).setvalue("email_sent"); // create sure cell updated right away in case script interrupted spreadsheetapp.flush(); } } }

email google-apps-script

Comments

Post a Comment

Popular posts from this blog

java - Bypassing "final local variable defined in an enclosing type" -

java - Bypassing "final local variable defined in an enclosing type" - i'm writing programme , i'm getting "the final local variable asd cannot assigned, since it's defined in enclosing type". i provide illustration not code produces error aswell. have arraylist utilize later (if define within button can't utilize later on), outside of button, pressing button should give values arraylist. in illustration "create new arraylist" cause same problem. button btn = new button("asd"); final arraylist asd = new arraylist(); btn.setonaction(new eventhandler<actionevent>() { public void handle(final actionevent event) { asd = new arraylist(); //here's error.. } }); clear arraylist , add together values. java javafx
Read more

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more