Skip to content

Instantly share code, notes, and snippets.

@takakabe

takakabe/mail_send.js

Created August 23, 2017 04:29
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save takakabe/2ef0cc39699a74e16feaa77ee544cdb8 to your computer and use it in GitHub Desktop.
Save takakabe/2ef0cc39699a74e16feaa77ee544cdb8 to your computer and use it in GitHub Desktop.
Download ZIP
Google Apps Script
Raw
mail_send.js
function mail_send() {
var sheet = SpreadsheetApp.getActiveSheet();
var to_address = sheet.getRange(1,1).getValue();
var mail_subject = sheet.getRange(2,1).getValue();
var mail_body = sheet.getRange(3,1).getValue();
MailApp.sendEmail(to_address,mail_subject,mail_body);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment