HwpBBfGC

1function convSheetAndEmail(rng, email, subj)
2{
3  var HTML = SheetConverter.convertRange2html(rng);
4  MailApp.sendEmail(email, subj, '', {htmlBody : HTML});
5}
6function doGet()
7{
8   var data = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
9
10  for (i in data) {
11    if (data[i][5] === ""){
12
13  var labels=new Array;
14    labels.push([data[i][0], data[i][1], data[i][2], data[i][3], data[i][4], data[i][5], data[i][6], data[i][7]]);  
15
16  var emailUser = '****@gmail.com';
17
18  var subject = 'Test Email';
19
20  convSheetAndEmail(labels, emailUser, subject);
21}
22}
23}