//http://code.google.com/intl/lv-LV/googleapps/appsscript/class_mailapp.html#sendEmail
function onFormSubmit(e) {
var timestamp = e.values[0];
var name = e.values[1];
var age = e.values[2];
var submitter = e.values[3];
// name + ", age " + age + " submitted by " + submitter + " on " + timestamp + "."
}
function send1(){
// try{
//var hrefText = '<a href="https://sites.google.com/site/28jan2011/">https://sites.google.com/site/28jan2011/</a>';
//var emailTextHTML1 = "<html><head></head><body><b>my message " + hrefText + "</b></body></html>";
var ss = SpreadsheetApp.getActiveSpreadsheet();
var textSubject = ss.getSheetByName("ЧИСЛА").getRange("B1").getValue();
var textBegin = ss.getSheetByName("ЧИСЛА").getRange("B2").getValue();
var textEnd = ss.getSheetByName("ЧИСЛА").getRange("B3").getValue();
var dataDig = ss.getSheetByName("ЧИСЛА").getRange("A5:A26").getValues();
var dataCol = ss.getSheetByName("ЧИСЛА").getRange("B5:B26").getValues();
for (var i = 0; i < 2; ++i){ //dataDig.length
Logger.log(dataDig[i].toString());
var textHTML = textBegin + "<font " + dataCol[i] + "><b> " + dataDig[i] + " </b></font>" + textEnd;
var advancedArgsM = advancedArgsFunc(textHTML);
MailApp.sendEmail("28janv2011@gmail.com", textSubject, "emailText:", advancedArgsM)
}// next i
try{
} catch(error) {
Logger.log("onFormSubmit Error: " + error);
//MailApp.sendEmail("jurijs.zarkovs@gmail.com", "onFormSubmit Error: " + error);
}
}
//<font style="color: rgb(56, 118, 29);" size="3"><b>3455</b></font>
function advancedArgsFunc(emailTextHTML){
var nameText = "ВЫКУП ПРИЧИНЫ";
var emailReplyTo = "";
var ccList = "";
var bccList = "";
//var resultPDF = DocsList.find(rowData.name);
//{attachments: myFiles}
//var emailTextHTML = "<html><head></head><body>my message</body></html>";
var advancedArgs = {name: nameText, replyTo: emailReplyTo, cc: ccList, bcc:bccList, htmlBody: emailTextHTML};
return advancedArgs;
}
Комментариев нет:
Отправить комментарий