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!');
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER