var EMAIL_SENT = "EMAIL_SENT";

function sentEmails(){

var sheet = SpreadsheetApp.getActiveSheet();

var startRow = 2;

var numRows = 2;

var dataRange = sheet.getRange(startRow,1,numRows,6);

var data = dataRange.getValues();

for (var i = 0; i < data.length; ++i) {

var row = data[i];

var emailAddress = row[0];

var message = "Dear " + row[1] + "\n\n";

message = message + row[3] + "\n\n";

message = message + "Yours sincerely," + "\n";

message = message + "Mr.Greecha Katpratoom";

var emailSent = row[5];

if (emailSent != EMAIL_SENT) {

var subject = row[2];

var picture1 = DriveApp.getFileById(row[4]);

MailApp.sendEmail({

to: emailAddress,

subject: subject,

body: message,

attachments: [picture1.getBlob()]

})

sheet.getRange(startRow + i, 6).setValue(EMAIL_SENT);

SpreadsheetApp.flush();

}

}

}