第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全，請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問題，去搜搜看，總會(huì)有你想問的

使用無效電子郵件從 googlesheet 發(fā)送電子郵件停止循環(huán)。如何跳過

使用無效電子郵件從 googlesheet 發(fā)送電子郵件停止循環(huán)。如何跳過

犯罪嫌疑人X 2022-12-29 15:12:07
我有一個(gè)發(fā)送電子郵件的 googlescript。它運(yùn)行良好，但似乎在遇到無效電子郵件時(shí)完全停止。有一個(gè)字段是手動(dòng)輸入的電子郵件地址，該地址會(huì)定期出現(xiàn)錯(cuò)誤。我離開辦公室一周，60 封電子郵件失敗，因?yàn)槟_本因電子郵件無效而停在一行，沒有繼續(xù)前進(jìn)。我不使用 javascript/googlescript 編寫，所以這對(duì)我來說是一個(gè)非常具有挑戰(zhàn)性的項(xiàng)目。我感謝任何幫助。如果電子郵件無效，我假設(shè)我需要添加一些內(nèi)容來跳過一行。我需要在腳本中更改什么？如果他/她輸入了無效的電子郵件地址（腳本是通過表單提交觸發(fā)的），是否有辦法將其推回提交者？如果有最佳實(shí)踐，我愿意接受替代方案和建議。錯(cuò)誤消息示例 “異常：無效電子郵件：gd@v.com、nt@v.com`、cb@v.com、zl@v.com at EmailHRBPonFormSubmit（自動(dòng)電子郵件提交：40:13）”function EmailTeamonFormSubmit() {    var sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Form Responses 1");  var startRow = 2;                              var numRows = sheet.getLastRow()-1;        // Number of rows to process  var lastColumn = sheet.getLastColumn();      // Last column  var dataRange = sheet.getRange(startRow, 1, numRows, lastColumn) // get the data range of the active sheet  var data = dataRange.getValues();            // get values for each row in the range  ////////////////////////////////////////////// //create a for loop; define variables based on increasing count, starting from zerofor (var i = 0;  i < data.length; i++) {  var row = data[i];    var emailSubmitter = row[1];    var submitter = row[5];    var emailStakeholder = row[11];    var stakeholder = row[10];    var jobName = row[12];    var emailSentStatus = row[49]    var BusinessPartneremail = row[47]    var BusninessPartnername = row[48]    var subject =  'New Submission: '+jobName;    var uniqueID = row[46]    var Responses = row[45] //copy of the entire form response        //message to the team    var message = "Hello, "+    BusninessPartnername+ ", " +stakeholder+       ""+    ", A new submission was sent by " +submitter+ ". The Unique ID is: " +uniqueID+ ". The responses are below."     }  }}
查看完整描述

1 回答

?
開心每一天1111

TA貢獻(xiàn)1836條經(jīng)驗(yàn) 獲得超13個(gè)贊

一個(gè)快速的解決方案是添加一個(gè)try/catch。本質(zhì)上，當(dāng)MailApp.sendEmail失敗時(shí)，腳本將從下一次迭代繼續(xù)，直到到達(dá)data.length.


像這樣包裝包含MailApp.sendEmail函數(shù)的 if 語句：


function EmailTeamonFormSubmit() {

  

  var sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Form Responses 1");

  var startRow = 2;                            

  var numRows = sheet.getLastRow()-1;        // Number of rows to process

  var lastColumn = sheet.getLastColumn();      // Last column

  var dataRange = sheet.getRange(startRow, 1, numRows, lastColumn) // get the data range of the active sheet

  var data = dataRange.getValues();            // get values for each row in the range



  //////////////////////////////////////////////

 //create a for loop; define variables based on increasing count, starting from zero


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

  var row = data[i];

    var emailSubmitter = row[1];

    var submitter = row[5];

    var emailStakeholder = row[11];

    var stakeholder = row[10];

    var jobName = row[12];

    var emailSentStatus = row[49]

    var BusinessPartneremail = row[47]

    var BusninessPartnername = row[48]

    var subject =  'New Submission: '+jobName;

    var uniqueID = row[46]

    var Responses = row[45] //copy of the entire form response

    

    //message to the team

    var message = "Hello, "+

    BusninessPartnername+ ", " +stakeholder+ 

      ""+

    ", A new submission was sent by " +submitter+ ". The Unique ID is: " +uniqueID+ ". The responses are below." 

   

    +Responses;

    //send emails only if Status and email Status criteria are met

      

  try{

  if (emailSentStatus !== "Team email Sent"){

    MailApp.sendEmail(emailSubmitter+", "+emailStakeholder+", "+BusinessPartneremail, subject, message,{noReply: true});  //write email and send

    

      sheet.getRange(startRow + i, lastColumn).setValue("Team email Sent");// write email sent when done 

      SpreadsheetApp.flush(); //refresh spreadsheet

    }

  } // try

  

  catch(e) {continue;}

  

}

}



查看完整回答
反對(duì) 回復(fù) 2022-12-29
  • 1 回答
  • 0 關(guān)注
  • 210 瀏覽
慕課專欄
更多

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

 幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

 公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)