Link to home
Start Free TrialLog in
Avatar of meet sidhu
meet sidhu

asked on

how i declare an array which contains email address corresponding to names.

how i declare an array which contains email address corresponding to names.i do not want write email address in google spreadsheet.the code automatically pick email address from coding corresponding to name.
function createHeaders() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var fSheet2 = ss.getSheets()[0];
   
  fSheet2.setFrozenRows(1);       // Freezes the first row
  var values = [
    ["NAME","Subject","message","Criterion"]
  ];            
  var range = fSheet2.getRange("A1:D1");        // Set the range of cells
  range.setValues(values);                    // Call the setValues method on range and pass in our values
  var values = [
    ["skaur","Testing email","hello","-5"]
   ];
  var range = fSheet2.getRange("A2:D2");
  range.setValues(values);
   var values = [
    ["nkaur@gmail.com","Testing email","hello","-2"]
   ];
  var range = fSheet2.getRange("A3:D3");
  range.setValues(values);
 }

function sendEmail(email_address, email_subject, email_message) {
  MailApp.sendEmail(email_address, email_subject, email_message);
}

 function test_sendEmail() {
  var fSheet2 = SpreadsheetApp.getActiveSheet();
  var cell = fSheet2.setActiveCell('A2');
  var criterion_cutoff = -5;
  var i = 0;
  var name;
  var subj;
  var msg;
  do {
    name = cell.offset(i,0).getValue();
    subj = cell.offset(i,1).getValue();
    msg = cell.offset(i,2).getValue();
   criterion = cell.offset(i,3).getValue();
    
    if(criterion == criterion_cutoff) {
      sendEmail(name,subj,msg);
      Browser.msgBox('Sending email to: ' + name);
    }
    i++;
  } while( cell.offset(i, 0).getValue().length > 0 )
    
  Browser.msgBox('Done!');
}

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Koen Van Wielink
Koen Van Wielink
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of meet sidhu
meet sidhu

ASKER

thank you so much