email - make a variable the text inside a cell -

-

i sending emails spreadsheet. want value of b2 body of email. way can type cell b2 want in message. have script set send charts , data contained in sheet, , works. when tried set body of email value of cell b2, sends message says "range" , adds charts.

my code looks far

function emailparentsupdates(sheet,emails,emailsubject){   var targetspreadsheet = spreadsheetapp.getactivespreadsheet();   var sheet = targetspreadsheet.getactivesheet();     var emailsubject = 'grades update';   var charts = sheet.getcharts();   var startrow = 1;  // first row of data process   var numrows = 1;   // number of rows process   var datarange = sheet.getrange(startrow, 1, numrows, 1)   var data = datarange.getvalues();   (i in data) {     var row = data[i];     var emailaddress = row[0];  // first column     var teacheremail = "efazekas@dcsdk12.org"      if(charts.length==0){       mailapp.sendemail({       to: teacheremail,       subject: "error:"+emailsubject,       htmlbody: "no charts in spreadsheet"});           return;     }         var chartblobs=new array(charts.length);     //this issue is. need email body value, actual words, of cell b2     var emailbody = sheet.getrange('b2');      var emailimages={};     for(var i=0;i<charts.length;i++){       var builder = charts[i].modify();       builder.setoption('vaxis.format', '#');       var newchart = builder.build();       chartblobs[i]= newchart.getas('image/png');       emailbody= emailbody + "<p align='center'><img src='cid:chart"+i+"'></p>";       emailimages["chart"+i]= chartblobs[i];     }      mailapp.sendemail({       to: emailaddress,       subject: emailsubject,       htmlbody: emailbody,       inlineimages:emailimages     });   } }

i know it's rough , maybe not succinct or elegant, need except whole email body issue. 

function getb2value(){   var sheet = spreadsheetapp.getactivesheet();   var range = sheet.getrange('b2');   return range.getvalue(); }

getrange() returns range, need call getvalue() reference value of cell. i.e:

var emailbody = sheet.getrange('b2').getvalue();

Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more