-
Notifications
You must be signed in to change notification settings - Fork 0
/
EmailSender
48 lines (37 loc) · 1.51 KB
/
EmailSender
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
function CheckColumnDate() {
var i = 2;
var j = 1;
while (i++) {
// get date from the first cell and iterate on the column
var rowDate = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Calendar").getRange("A"+i).getValue();
// get name of addressee from first cell and iterate on the column
var addressee = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Calendar").getRange("C"+i).getValue();
if (rowDate == "") break;
j=1;
// search the name of addressee email adress from the spreadsheet and iterate on the column
while(j++) {
var getNameToEmail = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("emailAddresses").getRange("A"+j).getValue();
if(getNameToEmail == addressee) {
var email = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("emailAddresses").getRange("B"+j).getValue();
EmailSender(rowDate, email);
break;
}
if (getNameToEmail == "") break;
}
}
}
// function to send the e-mail
function EmailSender(rowDate, email) {
// set format of date
var rowDateToDate = rowDate.getDate() + "-" + (rowDate.getMonth()+1) + "-" + rowDate.getFullYear()
// get today date
var today = new Date();
var todayToDate = today.getDate() + "-" + (today.getMonth()+1) + "-" + today.getFullYear();
// Check dates
if (rowDateToDate == todayToDate) {
// Send Alert Email.
var subject = 'Your e-mail subject';
var message = 'Your e-mail message :)';
MailApp.sendEmail(email, subject, message);
}
}