質問編集履歴

2

修正

2021/06/22 04:01

投稿

narururu
narururu

スコア172

test CHANGED
File without changes
test CHANGED
@@ -86,7 +86,7 @@
86
86
 
87
87
  var to = sheet.getRange(i,2).getValue();
88
88
 
89
- var flag = sheet.getRange(i,4).getValue();
89
+ var flag = sheet.getRange(i,3).getValue();
90
90
 
91
91
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
92
92
 

1

修正

2021/06/22 04:00

投稿

narururu
narururu

スコア172

test CHANGED
File without changes
test CHANGED
@@ -32,19 +32,11 @@
32
32
 
33
33
  var to = sheet.getRange(i,6).getValue();
34
34
 
35
- var name = sheet.getRange(i,2).getValue();
36
-
37
35
  var flag = sheet.getRange(i,7).getValue();
38
36
 
39
37
  if (flag != "NO"){
40
38
 
41
39
  var title = '【タイトル】';
42
-
43
- var body =
44
-
45
- name +
46
-
47
- '様\n\nお疲れ様です。テストメールです';
48
40
 
49
41
  GmailApp.sendEmail(
50
42
 
@@ -94,8 +86,6 @@
94
86
 
95
87
  var to = sheet.getRange(i,2).getValue();
96
88
 
97
- var name = sheet.getRange(i,3).getValue();
98
-
99
89
  var flag = sheet.getRange(i,4).getValue();
100
90
 
101
91
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~