Google表脚本，如果发送电子邮件为null，则跳过下一封电子邮件，如果已经发送了电子邮件

发布于 2025-02-12 14:10:26 字数 662 浏览 0 评论 0原文

我正在使用Google表脚本发送电子邮件，当电子邮件为空时，如何跳过一排？以及发送电子邮件时如何创建状态？

谢谢

function sendMails() {
  
  var wrkBk = SpreadsheetApp.getActiveSpreadsheet();
  var wrkShtEmailIDs= wrkBk.getSheetByName("recipient");
  var wrkShtMessage= wrkBk.getSheetByName("email_body");

  var subject = wrkShtMessage.getRange('A2').getValue();
  var message = wrkShtMessage.getRange('B2').getValue();

  for (var i=5;i<=100;i++){

      var emailAddress = wrkShtEmailIDs.getRange('C' + i).getValue();
      var finalmsg = "";
      finalmsg = "Hi " + emailAddress + "\n" + "\n" + message;
      MailApp.sendEmail(emailAddress, subject, finalmsg);

  }

}

原文

I'm using google sheets script to send an email,
how to skip a row when the email is null?
and how to create an status when the email is sent?

thank you

function sendMails() {
  
  var wrkBk = SpreadsheetApp.getActiveSpreadsheet();
  var wrkShtEmailIDs= wrkBk.getSheetByName("recipient");
  var wrkShtMessage= wrkBk.getSheetByName("email_body");

  var subject = wrkShtMessage.getRange('A2').getValue();
  var message = wrkShtMessage.getRange('B2').getValue();

  for (var i=5;i<=100;i++){

      var emailAddress = wrkShtEmailIDs.getRange('C' + i).getValue();
      var finalmsg = "";
      finalmsg = "Hi " + emailAddress + "\n" + "\n" + message;
      MailApp.sendEmail(emailAddress, subject, finalmsg);

  }

}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

一梦浮鱼 2025-02-19 14:10:26

例如，尝试尊重您的语法

function sendMails() {

  var wrkBk = SpreadsheetApp.getActiveSpreadsheet();
  var wrkShtEmailIDs = wrkBk.getSheetByName("recipient");
  var wrkShtMessage = wrkBk.getSheetByName("email_body");

  var subject = wrkShtMessage.getRange('A2').getValue();
  var message = wrkShtMessage.getRange('B2').getValue();

  for (var i = 5; i <= 100; i++) {

    var emailAddress = wrkShtEmailIDs.getRange('C' + i).getValue();

    if (emailAddress != '') {
      var finalmsg = "";
      finalmsg = "Hi " + emailAddress + "\n" + "\n" + message;
      MailApp.sendEmail(emailAddress, subject, finalmsg);
      wrkShtMessage.getRange('D' + i).setValue('sent') // status in D
    }

  }

}

Try for instance, respecting your syntax

function sendMails() {

  var wrkBk = SpreadsheetApp.getActiveSpreadsheet();
  var wrkShtEmailIDs = wrkBk.getSheetByName("recipient");
  var wrkShtMessage = wrkBk.getSheetByName("email_body");

  var subject = wrkShtMessage.getRange('A2').getValue();
  var message = wrkShtMessage.getRange('B2').getValue();

  for (var i = 5; i <= 100; i++) {

    var emailAddress = wrkShtEmailIDs.getRange('C' + i).getValue();

    if (emailAddress != '') {
      var finalmsg = "";
      finalmsg = "Hi " + emailAddress + "\n" + "\n" + message;
      MailApp.sendEmail(emailAddress, subject, finalmsg);
      wrkShtMessage.getRange('D' + i).setValue('sent') // status in D
    }

  }

}

回复收藏 0 原文

~没有更多了~