{"id":6086,"date":"2021-10-05T10:29:17","date_gmt":"2021-10-05T01:29:17","guid":{"rendered":"https:\/\/blog.synnex.co.jp\/?p=6086"},"modified":"2022-01-19T16:37:26","modified_gmt":"2022-01-19T07:37:26","slug":"gas-sending-email-all-at-once","status":"publish","type":"post","link":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011"},"content":{"rendered":"\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u3067\u4e00\u89a7\u306b\u306a\u3063\u3066\u3044\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3078\u3001\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308bGoogleAppsScript\u306e\u5fdc\u7528\u7de8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u6982\u8981\">\u6982\u8981<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E6%A6%82%E8%A6%81\"><\/a><\/h2>\n\n\n\n<p>\u524d\u56de\u306f<a href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/sending-email-from-spreadsheet\/\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript<\/a>\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<br>\u4eca\u56de\u306f\u305d\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u4e0b\u8a18\u3092\u4f5c\u6210\u30fb\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0<\/li><li>\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1<\/li><\/ol>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5074\u306f\u524d\u56de\u3068\u540c\u3058\u3082\u306e\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"322\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/001_ss_default-1.png\" alt=\"\" class=\"wp-image-6087\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/001_ss_default-1.png 624w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/001_ss_default-1-300x155.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\">1. \u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#1-%E3%83%A1%E3%83%BC%E3%83%AB%E6%9C%AC%E6%96%87%E3%81%AB%E5%90%84%E5%AE%9B%E5%85%88%E3%81%AE%E5%90%8D%E5%89%8D%E3%82%92%E8%BF%BD%E5%8A%A0\"><\/a><\/h2>\n\n\n\n<p>\u524d\u56de\u4f5c\u6210\u3057\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u306f\u30e1\u30fc\u30eb\u672c\u6587\u306e\u5192\u982d\u304c\u5168\u54e1\u300c\u793e\u54e1\u306e\u7686\u3055\u307e\u300d\u3068\u306a\u3063\u3066\u3044\u307e\u3057\u305f\u3002<br>\u305d\u306e\u307e\u307e\u3082\u60aa\u304f\u306f\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u5c11\u3057\u7c21\u7d20\u3060\u3063\u305f\u306e\u3067\u300c\u3007\u7530\u25b3\u592a \u3055\u3093\u300d\u306e\u3088\u3046\u306b\u30e1\u30fc\u30eb\u5192\u982d\u3092\u540d\u524d\u306b\u5909\u3048\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u540d\u524d\u30ea\u30b9\u30c8\u306e\u53d6\u5f97\">\u540d\u524d\u30ea\u30b9\u30c8\u306e\u53d6\u5f97<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E5%90%8D%E5%89%8D%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AE%E5%8F%96%E5%BE%97\"><\/a><\/h3>\n\n\n\n<p>\u307e\u305a\u306f\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u305f\u306e\u3068\u540c\u3058\u8981\u9818\u3067\u3001\u9001\u4ed8\u5148\u306e\u540d\u524d\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function main() {\n\nconst ss = SpreadsheetApp.getActiveSpreadsheet();\nconst sheet = ss.getSheetByName(&#39;\u30a2\u30c9\u30ec\u30b9\u5e33&#39;);\n\nconst firstRow = 4;\nconst mailCol = 3;\n\nvar rowLength = sheet.getLastRow() - (firstRow - 1);\n\nvar mailaddressList = [];\n\n\/\/ ----\u3053\u3053\u3088\u308a\u4e0a\u306f\u524d\u56de\u306e\u5185\u5bb9----\n\n\nconst nameCol = 2;  \/\/\u540d\u524d\u306e\u5217(=\u4eca\u56de\u306fB\u5217)\n\nvar nameList = [];\n\n\/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u30ea\u30b9\u30c8\u3001\u540d\u524d\u30ea\u30b9\u30c8\u53d6\u5f97\nfor(let i=0; i &lt; rowLength; i++){\n\n  let address = sheet.getRange(firstRow + i, mailCol).getValue();\n  mailaddressList.push(address);\n\n  let name = sheet.getRange(firstRow + i, nameCol).getValue();\n  nameList.push(name);\n}\n\n\n\/\/----\u4ee5\u4e0b\u3001\u524d\u56de\u5185\u5bb9----\n\n\/\/ \u5b9b\u5148\u3054\u3068\u306b\u30e1\u30fc\u30eb\u4f5c\u6210\u3001\u9001\u4fe1\n  mailaddressList.forEach(address =&gt; {\n\n    \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u3042\u308b\u5834\u5408\u3001\u5b9f\u884c\n    if(address != &#39;&#39;){\n\n      sendMailToAll(address);\n    }\n  });\n\n}<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u30ea\u30b9\u30c8\u304b\u3089\u5bfe\u8c61\u306e\u540d\u524d\u3092\u53d6\u5f97\">\u30ea\u30b9\u30c8\u304b\u3089\u5bfe\u8c61\u306e\u540d\u524d\u3092\u53d6\u5f97<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E3%83%AA%E3%82%B9%E3%83%88%E3%81%8B%E3%82%89%E5%AF%BE%E8%B1%A1%E3%81%AE%E5%90%8D%E5%89%8D%E3%82%92%E5%8F%96%E5%BE%97\"><\/a><\/h3>\n\n\n\n<p>\u5b9b\u5148\u3054\u3068\u306b\u30e1\u30fc\u30eb\u4f5c\u6210\u3001\u9001\u4fe1\u3092forEach\u3067\u884c\u3046\u969b\u3001index\u3092\u7528\u3044\u3066\u5bfe\u8c61\u306e\u540d\u524d\u3092<code>nameList<\/code>\u304b\u3089\u53d6\u5f97\u3057\u307e\u3059\u3002<br>\u30e1\u30fc\u30eb\u4f5c\u6210\u30fb\u9001\u4fe1\u3092\u884c\u3046<code>sendMailToAll<\/code>\u3078\u6e21\u3059\u30c7\u30fc\u30bf\u306b\u53d6\u5f97\u3057\u305f\u540d\u524d\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function main() {\n\n\/\/ ----\u3053\u308c\u307e\u3067\u306e\u5185\u5bb9----\n\n\n\/\/ \u5b9b\u5148\u3054\u3068\u306b\u30e1\u30fc\u30eb\u4f5c\u6210\u3001\u9001\u4fe1\nmailaddressList.forEach((address, index) =&gt; {\n\n  \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u3042\u308b\u5834\u5408\u3001\u5b9f\u884c\n  if(address != &#39;&#39;){\n\n    let name = nameList[index];\n\n    sendMailToAll(address, name);\n  }\n});\n\n}\n<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u30e1\u30fc\u30eb\u672c\u6587\u306b\u540d\u524d\u3092\u7f6e\u304d\u63db\u3048\">\u30e1\u30fc\u30eb\u672c\u6587\u306b\u540d\u524d\u3092\u7f6e\u304d\u63db\u3048<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E3%83%A1%E3%83%BC%E3%83%AB%E6%9C%AC%E6%96%87%E3%81%AB%E5%90%8D%E5%89%8D%E3%82%92%E7%BD%AE%E3%81%8D%E6%8F%9B%E3%81%88\"><\/a><\/h3>\n\n\n\n<p>\u30e1\u30fc\u30eb\u672c\u6587\u306b\u540d\u524d\u3092\u5165\u308c\u308b\u969b\u306b\u306f\u672c\u6587\u306e\u3072\u306a\u5f62\u3092<code>bodyTemplate<\/code>\u3067\u4f5c\u6210\u3057\u3001<code>replace<\/code>\u30e1\u30bd\u30c3\u30c9\u3092\u7528\u3044\u3066\u540d\u524d\u3092\u7f6e\u304d\u63db\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function sendMailToAll(address, name) {\n  const subject = &#39;\u3010\u5168\u4f53\u9023\u7d61\u3011\u30b7\u30b9\u30c6\u30e0\u4f11\u6b62\u65e5\u306b\u3064\u3044\u3066&#39;; \/\/ \u30e1\u30fc\u30eb\u306e\u4ef6\u540d\n\n  const bodyTemplate = `\n{name} \u3055\u3093\n\n~~\u30e1\u30fc\u30eb\u672c\u6587~~\n\n`;\n\nlet body = bodyTemplate\n    .replace(&#39;{name}&#39;, name);\n\nGmailApp.sendEmail(address, subject, body);\n\n}<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u5b8c\u6210\">\u5b8c\u6210<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E5%AE%8C%E6%88%90\"><\/a><\/h3>\n\n\n\n<p>\u4f5c\u6210\u3057\u305f\u30b3\u30fc\u30c9\u306e\u5168\u4f53\u3067\u3059\u3002<br>\u5b9a\u6570\u3084\u5909\u6570\u306e\u5ba3\u8a00\u90e8\u5206\u3092\u5c11\u3057\u6574\u7406\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function main() {\n\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30a2\u30c9\u30ec\u30b9\u5e33&#39;);\n\n  const firstRow = 4; \/\/\u30c7\u30fc\u30bf\u306e\u958b\u59cb\u884c(=\u4eca\u56de\u306f4\u884c\u76ee)\n  const mailCol = 3;  \/\/\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u306e\u5217(=\u4eca\u56de\u306fC\u5217)\n  const nameCol = 2;  \/\/\u540d\u524d\u306e\u5217(=\u4eca\u56de\u306fB\u5217)\n\n  var rowLength = sheet.getLastRow() - (firstRow - 1);\n\n  var mailaddressList = [];\n  var nameList = [];\n\n  \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u30ea\u30b9\u30c8\u3001\u540d\u524d\u30ea\u30b9\u30c8\u53d6\u5f97\n  for(let i=0; i &lt; rowLength; i++){\n\n    let address = sheet.getRange(firstRow + i, mailCol).getValue();\n    mailaddressList.push(address);\n\n    let name = sheet.getRange(firstRow + i, nameCol).getValue();\n    nameList.push(name);\n  }\n\n  \/\/ \u5b9b\u5148\u3054\u3068\u306b\u30e1\u30fc\u30eb\u4f5c\u6210\u3001\u9001\u4fe1\n  mailaddressList.forEach((address, index) =&gt; {\n\n    \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u3042\u308b\u5834\u5408\u3001\u5b9f\u884c\n    if(address != &#39;&#39;){\n\n      let name = nameList[index];\n\n      sendMail(address, name);\n    }\n  });\n\n}\n\nfunction sendMail(address, name) {\n  const subject = &#39;\u3010\u5168\u4f53\u9023\u7d61\u3011\u30b7\u30b9\u30c6\u30e0\u4f11\u6b62\u65e5\u306b\u3064\u3044\u3066&#39;; \/\/ \u30e1\u30fc\u30eb\u306e\u4ef6\u540d\n\n  const bodyTemplate = `\n{name} \u3055\u3093\n\n\u7dcf\u52d9\u90e8\u3088\u308a\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u4f11\u6b62\u65e5\u306b\u3064\u3044\u3066\u304a\u77e5\u3089\u305b\u3067\u3059\u3002\n\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u306e\u5165\u308c\u66ff\u3048\u306b\u4f34\u3044\u300120XX\u5e74\u3007\u6708\u3007\u65e5\u306f\u7d42\u65e5\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u304c\u4f11\u6b62\u3068\u306a\u308a\u307e\u3059\u3002\n\u95a2\u4fc2\u90e8\u7f72\u306b\u304a\u3044\u3066\u306f\u696d\u52d9\u8abf\u6574\u3092\u3088\u308d\u3057\u304f\u304a\u9858\u3044\u3044\u305f\u3057\u307e\u3059\u3002\n\n\u8a73\u7d30\u5185\u5bb9\u306b\u3064\u3044\u3066\u306f\u793e\u5185\u30a4\u30f3\u30c8\u30e9\u306b\u63b2\u793a\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u3054\u4e00\u8aad\u304f\u3060\u3055\u3044\u3002\nhttps:\/\/\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\/\n\n\u5404\u7a2e\u554f\u3044\u5408\u308f\u305b\u306f\u90e8\u9580\u5185\u3067\u53d6\u308a\u307e\u3068\u3081\u306e\u4e0a\u3001\u7dcf\u52d9\u90e8\u307e\u3067\u304a\u9858\u3044\u3044\u305f\u3057\u307e\u3059\u3002\n\n\u7dcf\u52d9\u90e8\u3000\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u62c5\u5f53\u3000\u3007\u3007\n\u5185\u7dda\uff1a000-000-0000\n\n`;\n\nlet body = bodyTemplate\n    .replace(&#39;{name}&#39;, name);\n\nGmailApp.sendEmail(address, subject, body);\n\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u9001\u4fe1\u30e1\u30fc\u30eb\u7d50\u679c\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"585\" height=\"402\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/001_mail.png\" alt=\"\" class=\"wp-image-6088\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/001_mail.png 585w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/001_mail-300x206.png 300w\" sizes=\"auto, (max-width: 585px) 100vw, 585px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2-\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\">2. \u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#2-%E7%89%B9%E5%AE%9A%E3%81%AE%E9%83%A8%E7%BD%B2%E3%81%AE%E4%BA%BA%E3%81%AB%E3%81%A0%E3%81%91%E3%83%A1%E3%83%BC%E3%83%AB%E3%82%92%E9%80%81%E4%BF%A1\"><\/a><\/h2>\n\n\n\n<p>\u30a2\u30c9\u30ec\u30b9\u5e33\u306e\u4e2d\u306e\u5168\u54e1\u3067\u306f\u306a\u304f\u4f55\u4eba\u304b\u306e\u307f\u306b\u30e1\u30fc\u30eb\u3092\u9001\u308a\u305f\u3044\u5834\u5408\u3082\u3042\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<br>\u4eca\u56de\u306f\u6240\u5c5e\u304c\u300c\u55b6\u696d\u90e8\u300d\u306b\u306a\u3063\u3066\u3044\u308b\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"322\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/002_ss_sales.png\" alt=\"\" class=\"wp-image-6089\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/002_ss_sales.png 624w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/002_ss_sales-300x155.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u90e8\u7f72\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\">\u90e8\u7f72\u30ea\u30b9\u30c8\u3092\u53d6\u5f97<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E9%83%A8%E7%BD%B2%E3%83%AA%E3%82%B9%E3%83%88%E3%82%92%E5%8F%96%E5%BE%97\"><\/a><\/h3>\n\n\n\n<p>\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3084\u524d\u9805\u306e\u540d\u524d\u30ea\u30b9\u30c8\u3068\u540c\u69d8\u306b\u90e8\u7f72\u306e\u30ea\u30b9\u30c8\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>const departmentCol = 4;  \/\/\u90e8\u7f72\u306e\u5217(=\u4eca\u56de\u306fD\u5217)\n\nvar departmentList = [];\n\n  \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u30ea\u30b9\u30c8\u3001\u540d\u524d\u30ea\u30b9\u30c8\u3001\u90e8\u7f72\u30ea\u30b9\u30c8\u53d6\u5f97\nfor(let i=0; i &lt; rowLength; i++){\n\n  let address = sheet.getRange(firstRow + i, mailCol).getValue();\n  mailaddressList.push(address);\n\n  let name = sheet.getRange(firstRow + i, nameCol).getValue();\n  nameList.push(name);\n\n  let department = sheet.getRange(firstRow + i, departmentCol).getValue();\n  departmentList.push(department);\n}<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u30e1\u30fc\u30eb\u4f5c\u6210\u9001\u4fe1\u6642\u306e\u6761\u4ef6\u3092\u5909\u66f4\">\u30e1\u30fc\u30eb\u4f5c\u6210\u30fb\u9001\u4fe1\u6642\u306e\u6761\u4ef6\u3092\u5909\u66f4<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E3%83%A1%E3%83%BC%E3%83%AB%E4%BD%9C%E6%88%90%E9%80%81%E4%BF%A1%E6%99%82%E3%81%AE%E6%9D%A1%E4%BB%B6%E3%82%92%E5%A4%89%E6%9B%B4\"><\/a><\/h3>\n\n\n\n<p>\u30e1\u30fc\u30eb\u3092\u4f5c\u6210\u30fb\u9001\u4fe1\u3059\u308b\u969b\u306e\u6761\u4ef6\u306b\u90e8\u7f72\u306e\u5224\u5b9a\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>\u3053\u308c\u3067\u3001\u55b6\u696d\u90e8\u4ee5\u5916\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u304c\u9001\u4fe1\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ \u5b9b\u5148\u3054\u3068\u306b\u30e1\u30fc\u30eb\u4f5c\u6210\u3001\u9001\u4fe1\nmailaddressList.forEach((address, index) =&gt; {\n\n  \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u3042\u308a\u3001\u55b6\u696d\u90e8\u306e\u6240\u5c5e\u306e\u5834\u5408\u306e\u307f\u5b9f\u884c\n  if(address != &#39;&#39; && departmentList[index] == &quot;\u55b6\u696d\u90e8&quot;){\n\n    let name = nameList[index];\n\n    sendMailToSales(address, name);\n  }\n});\n<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"\u5b8c\u6210-1\">\u5b8c\u6210<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E5%AE%8C%E6%88%90-1\"><\/a><\/h3>\n\n\n\n<p>\u4f5c\u6210\u3057\u305f\u30b3\u30fc\u30c9\u306e\u5168\u4f53\u3067\u3059\u3002<br>\u305b\u3063\u304b\u304f\u306a\u306e\u3067\u30e1\u30fc\u30eb\u306e\u672c\u6587\u3082\u5909\u3048\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function main() {\n\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30a2\u30c9\u30ec\u30b9\u5e33&#39;);\n\n  const firstRow = 4;       \/\/\u30c7\u30fc\u30bf\u306e\u958b\u59cb\u884c(=\u4eca\u56de\u306f4\u884c\u76ee)\n  const mailCol = 3;        \/\/\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u306e\u5217(=\u4eca\u56de\u306fC\u5217)\n  const nameCol = 2;        \/\/\u540d\u524d\u306e\u5217(=\u4eca\u56de\u306fB\u5217)\n  const departmentCol = 4;  \/\/\u90e8\u7f72\u306e\u5217(=\u4eca\u56de\u306fD\u5217)\n\n  var rowLength = sheet.getLastRow() - (firstRow - 1);\n\n  var mailaddressList = [];\n  var nameList = [];\n  var departmentList = [];\n\n  \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u30ea\u30b9\u30c8\u3001\u540d\u524d\u30ea\u30b9\u30c8\u3001\u90e8\u7f72\u30ea\u30b9\u30c8\u53d6\u5f97\n  for(let i=0; i &lt; rowLength; i++){\n\n    let address = sheet.getRange(firstRow + i, mailCol).getValue();\n    mailaddressList.push(address);\n\n    let name = sheet.getRange(firstRow + i, nameCol).getValue();\n    nameList.push(name);\n\n    let department = sheet.getRange(firstRow + i, departmentCol).getValue();\n    departmentList.push(department);\n  }\n\n  \/\/ \u5b9b\u5148\u3054\u3068\u306b\u30e1\u30fc\u30eb\u4f5c\u6210\u3001\u9001\u4fe1\n  mailaddressList.forEach((address, index) =&gt; {\n\n    \/\/ \u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u304c\u3042\u308a\u3001\u55b6\u696d\u90e8\u306e\u6240\u5c5e\u306e\u5834\u5408\u306e\u307f\u5b9f\u884c\n    if(address != &#39;&#39; && departmentList[index] == &quot;\u55b6\u696d\u90e8&quot;){\n\n      let name = nameList[index];\n\n      sendMailToSales(address, name);\n    }\n  })\n\n}\n\nfunction sendMailToSales(address, name) {\n  const subject = &#39;\u3010\u9023\u7d61\u3011\u55b6\u696d\u5411\u3051\u30b7\u30b9\u30c6\u30e0\u4f11\u6b62\u65e5\u306b\u3064\u3044\u3066&#39;; \/\/ \u30e1\u30fc\u30eb\u306e\u4ef6\u540d\n\n  const bodyTemplate = `\n\u55b6\u696d\u90e8\u3000{name} \u3055\u3093\n\n\u7dcf\u52d9\u90e8\u3088\u308a\u55b6\u696d\u5411\u3051\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u4f11\u6b62\u65e5\u306b\u3064\u3044\u3066\u304a\u77e5\u3089\u305b\u3067\u3059\u3002\n\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u306e\u5165\u308c\u66ff\u3048\u306b\u4f34\u3044\u300120XX\u5e74\u3007\u6708\u3007\u65e5\u306f\u7d42\u65e5\u55b6\u696d\u5411\u3051\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u304c\u4f11\u6b62\u3068\u306a\u308a\u307e\u3059\u3002\n\u95a2\u4fc2\u90e8\u7f72\u306b\u304a\u3044\u3066\u306f\u696d\u52d9\u8abf\u6574\u3092\u3088\u308d\u3057\u304f\u304a\u9858\u3044\u3044\u305f\u3057\u307e\u3059\u3002\n\n\u8a73\u7d30\u5185\u5bb9\u306b\u3064\u3044\u3066\u306f\u793e\u5185\u30a4\u30f3\u30c8\u30e9\u306b\u63b2\u793a\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u3054\u4e00\u8aad\u304f\u3060\u3055\u3044\u3002\nhttps:\/\/\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\u3007\/\n\n\u5404\u7a2e\u554f\u3044\u5408\u308f\u305b\u306f\u90e8\u9580\u5185\u3067\u53d6\u308a\u307e\u3068\u3081\u306e\u4e0a\u3001\u7dcf\u52d9\u90e8\u307e\u3067\u304a\u9858\u3044\u3044\u305f\u3057\u307e\u3059\u3002\n\n\u7dcf\u52d9\u90e8\u3000\u793e\u5185\u30b7\u30b9\u30c6\u30e0\u62c5\u5f53\u3000\u3007\u3007\n\u5185\u7dda\uff1a000-000-0000\n\n`;\n\nlet body = bodyTemplate\n    .replace(&#39;{name}&#39;, name)\n\nGmailApp.sendEmail(address, subject, body);\n\n}\n<\/code><\/pre><\/div>\n\n\n\n<p>\u9001\u4fe1\u30e1\u30fc\u30eb\u7d50\u679c\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"397\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/003_mail.png\" alt=\"\" class=\"wp-image-6090\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/003_mail.png 604w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/003_mail-300x197.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u307e\u3068\u3081\">\u307e\u3068\u3081<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/sendmail-fromss-advanced.html#%E3%81%BE%E3%81%A8%E3%82%81\"><\/a><\/h2>\n\n\n\n<p>GAS\u3092\u7528\u3044\u3066\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u969b\u306e\u5fdc\u7528\u306e\u7d39\u4ecb\u3067\u3057\u305f\u3002<br>\u3053\u308c\u3089\u306b\u30e1\u30fc\u30eb\u9001\u4fe1\u6642\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u8a2d\u5b9a\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3068\u3001\u90e8\u7f72\u306b\u3088\u3063\u3066\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u3048\u305f\u308aCC\u3092\u8ffd\u52a0\u3057\u305f\u308a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<br>\u305c\u3072\u6d3b\u7528\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>&lt;div class=&quot;p-3 mb-4 bg-light rounded-3&quot;&gt;\n    &lt;div class=&quot;container-fluid&quot;&gt;\n      &lt;h4 class=&quot;display-6 fw-bold&quot;&gt;&lt;span id=&quot;Google_workspace&quot;&gt;Google Workspace\u306e\u5c0e\u5165\u306f\u5f53\u793e\u306b\u304a\u4efb\u305b\u304f\u3060\u3055\u3044&lt;\/span&gt;&lt;\/h4&gt;\n      &lt;p class=&quot;col-md-12&quot;&gt;IT\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30bf\u30fc\u3067\u3042\u308b\u3001TD \u30b7\u30cd\u30c3\u30af\u30b9\u306fGoogle Cloud\u2122 Partner Award \u3092\u53d7\u8cde\u3059\u308b\u306a\u3069\u3001\u9577\u5e74\u306b\u308f\u305f\u308aGoogle\u2122\u306e\u30b0\u30ed\u30fc\u30d0\u30eb\u8a8d\u5b9a\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30bf\u30fc\u3068\u3057\u3066\u3001\u7dcf\u5408\u7684\u306a Google\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u304a\u5ba2\u69d8\u306b\u3068\u3063\u3066\u6700\u9069\u306a\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u306e\u63d0\u6848\u3084\u5c0e\u5165\u3001\u6d3b\u7528\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002&lt;\/p&gt;\n      &lt;a href=&quot;https:\/\/www.synnex.co.jp\/vender\/google\/inquiry\/&quot;&gt;&lt;button class=&quot;btn btn-primary btn-lg&quot; type=&quot;button&quot;&gt;\u304a\u554f\u3044\u5408\u308f\u305b&lt;\/button&gt;&lt;\/a&gt;\n    &lt;\/div&gt;\n&lt;\/div&gt;<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u3067\u4e00\u89a7\u306b\u306a\u3063\u3066\u3044\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u3078\u3001\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308bGoogleAppsScript\u306e\u5fdc\u7528\u7de8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u6982\u8981 \u524d\u56de\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleApp&#8230;<\/p>\n","protected":false},"author":3,"featured_media":6267,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[169],"tags":[161],"class_list":["post-6086","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google","tag-gas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011 &#8211; TD SYNNEX BLOG<\/title>\n<meta name=\"description\" content=\"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript\uff08GAS\uff09\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3068\u3068\u3082\u306b\u3001\u2460\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3001\u2461\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u65b9\u6cd5\u3001\u3092\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011 &#8211; TD SYNNEX BLOG\" \/>\n<meta property=\"og:description\" content=\"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript\uff08GAS\uff09\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3068\u3068\u3082\u306b\u3001\u2460\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3001\u2461\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u65b9\u6cd5\u3001\u3092\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/\" \/>\n<meta property=\"og:site_name\" content=\"TD SYNNEX BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-05T01:29:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-19T07:37:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1099\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"TD SYNNEX K.K.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"TD SYNNEX K.K.\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/\",\"url\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/\",\"name\":\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011 &#8211; TD SYNNEX BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg\",\"datePublished\":\"2021-10-05T01:29:17+00:00\",\"dateModified\":\"2022-01-19T07:37:26+00:00\",\"author\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/27a28c43d8bfc7e8087223b26535d233\"},\"description\":\"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript\uff08GAS\uff09\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3068\u3068\u3082\u306b\u3001\u2460\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3001\u2461\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u65b9\u6cd5\u3001\u3092\u8aac\u660e\u3057\u307e\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#primaryimage\",\"url\":\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg\",\"contentUrl\":\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg\",\"width\":1920,\"height\":1099},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/jp.tdsynnex.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google\",\"item\":\"https:\/\/jp.tdsynnex.com\/blog\/category\/google\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#website\",\"url\":\"https:\/\/jp.tdsynnex.com\/blog\/\",\"name\":\"TD SYNNEX BLOG\",\"description\":\"IT\u5c02\u9580\u5546\u793e\u304c\u5c4a\u3051\u308b\u60c5\u5831\u30e1\u30c7\u30a3\u30a2\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jp.tdsynnex.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/27a28c43d8bfc7e8087223b26535d233\",\"name\":\"TD SYNNEX K.K.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8c78c73b44737d0e9ea65e8b304502f5d063717571c4be4b0904e52c0d3c3229?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8c78c73b44737d0e9ea65e8b304502f5d063717571c4be4b0904e52c0d3c3229?s=96&d=mm&r=g\",\"caption\":\"TD SYNNEX K.K.\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011 &#8211; TD SYNNEX BLOG","description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript\uff08GAS\uff09\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3068\u3068\u3082\u306b\u3001\u2460\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3001\u2461\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u65b9\u6cd5\u3001\u3092\u8aac\u660e\u3057\u307e\u3059\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/","og_locale":"ja_JP","og_type":"article","og_title":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011 &#8211; TD SYNNEX BLOG","og_description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript\uff08GAS\uff09\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3068\u3068\u3082\u306b\u3001\u2460\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3001\u2461\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u65b9\u6cd5\u3001\u3092\u8aac\u660e\u3057\u307e\u3059\u3002","og_url":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/","og_site_name":"TD SYNNEX BLOG","article_published_time":"2021-10-05T01:29:17+00:00","article_modified_time":"2022-01-19T07:37:26+00:00","og_image":[{"width":1920,"height":1099,"url":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg","type":"image\/jpeg"}],"author":"TD SYNNEX K.K.","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"TD SYNNEX K.K.","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"4\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/","url":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/","name":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011 &#8211; TD SYNNEX BLOG","isPartOf":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#primaryimage"},"image":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#primaryimage"},"thumbnailUrl":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg","datePublished":"2021-10-05T01:29:17+00:00","dateModified":"2022-01-19T07:37:26+00:00","author":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/27a28c43d8bfc7e8087223b26535d233"},"description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff09\u4e0a\u306b\u3042\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u4e00\u89a7\u3078\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGoogleAppsScript\uff08GAS\uff09\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306e\u5fdc\u7528\u7de8\u3068\u3057\u3066\u3001\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3068\u3068\u3082\u306b\u3001\u2460\u30e1\u30fc\u30eb\u672c\u6587\u306b\u5404\u5b9b\u5148\u306e\u540d\u524d\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u3001\u2461\u7279\u5b9a\u306e\u90e8\u7f72\u306e\u4eba\u306b\u3060\u3051\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u65b9\u6cd5\u3001\u3092\u8aac\u660e\u3057\u307e\u3059\u3002","breadcrumb":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#primaryimage","url":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg","contentUrl":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/09\/contact-us-4193637_1920.jpg","width":1920,"height":1099},{"@type":"BreadcrumbList","@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-sending-email-all-at-once\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/jp.tdsynnex.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Google","item":"https:\/\/jp.tdsynnex.com\/blog\/category\/google\/"},{"@type":"ListItem","position":3,"name":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30e1\u30fc\u30eb\u3092\u4e00\u6589\u9001\u4fe1\u3059\u308bGAS\u3010\u5fdc\u7528\u7de8\u3011"}]},{"@type":"WebSite","@id":"https:\/\/jp.tdsynnex.com\/blog\/#website","url":"https:\/\/jp.tdsynnex.com\/blog\/","name":"TD SYNNEX BLOG","description":"IT\u5c02\u9580\u5546\u793e\u304c\u5c4a\u3051\u308b\u60c5\u5831\u30e1\u30c7\u30a3\u30a2","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jp.tdsynnex.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/27a28c43d8bfc7e8087223b26535d233","name":"TD SYNNEX K.K.","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8c78c73b44737d0e9ea65e8b304502f5d063717571c4be4b0904e52c0d3c3229?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8c78c73b44737d0e9ea65e8b304502f5d063717571c4be4b0904e52c0d3c3229?s=96&d=mm&r=g","caption":"TD SYNNEX K.K."}}]}},"_links":{"self":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts\/6086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/comments?post=6086"}],"version-history":[{"count":7,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts\/6086\/revisions"}],"predecessor-version":[{"id":6911,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts\/6086\/revisions\/6911"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/media\/6267"}],"wp:attachment":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/media?parent=6086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/categories?post=6086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/tags?post=6086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}