Script

How do you do, when you should send email periodically? With Google Apps Script, we can send email automatically and periodically.

First, wrote the code to send email like below.

function scheduleMail() {
var dateString = Utilities.formatDate(new Date(),"GMT+09:00","yyyy/MM/dd");
var mailto = "to@mail.com";
var subject = dateString + " mail title";
var message = "Hello everyone!nnI am Kenji.n";
message += "I have something to tell you on this weekend.nn";
message += "- Donation -n";
message += "Feel free to donate to me.n";
message += "reference: http://test.com";
message += "nn";
message += "- Contribution -n";
message += "Feel free to contribute money to me.nn";
MailApp.sendEmail(mailto, subject, message);
return 0;
}

function scheduleMail() {

var dateString = Utilities.formatDate(new Date(),"GMT+09:00","yyyy/MM/dd");

var mailto = "to@mail.com";

var subject = dateString + " mail title";

var message = "Hello everyone!nnI am Kenji.n";

message += "I have something to tell you on this weekend.nn";

message += "- Donation -n";

message += "Feel free to donate to me.n";

message += "reference: http://test.com";

message += "nn";

message += "- Contribution -n";

message += "Feel free to contribute money to me.nn";

MailApp.sendEmail(mailto, subject, message);

return 0;

}

You can add CC and BCC on the email.

And now, select “Resources” from menu, and click “Current project’s triggers”, and follow the instructions and create a trigger to execute sending method periodically. You can send email everyday, or on the specific weekdays, or beginning or end of month, etc. Notification email is available, which tells you the information when program fails.

In the above case, I use MailApp for sending email、 You can send email according to you or other’s calendar, using CalendarApp. Detail of MailApp or CalendarApp, Utilities is on the online document published by Google.