Advertisement
Guest User

Untitled

a guest
Feb 21st, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.49 KB | None | 0 0
  1. function sendEmailsToStaff()
  2. {
  3.  
  4.   if (Browser.msgBox('Are you sure you would like to continue?', Browser.Buttons.YES_NO) == 'yes')
  5.   {
  6.     var emailMessage = SpreadsheetApp.getActiveSheet().getRange("Statement Data Input!H5").getValue();
  7.     var emailSubject = SpreadsheetApp.getActiveSheet().getRange("Statement Data Input!G5").getValue();
  8.    
  9.     var senderEmail = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Statement Data input").getRange("Statement Data input!D2").getValue();
  10.     var senderName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Statement Data input").getRange("Statement Data input!C2").getValue();
  11.    
  12.     var emailAddresses = [SpreadsheetApp.getActiveSpreadsheet().getSheetByName("staff1").getRange("staff1!B5").getValue(),SpreadsheetApp.getActiveSpreadsheet().getSheetByName("staff2").getRange("staff2!B5").getValue()];
  13.    
  14.     var validEmails = [];
  15.    
  16.     for (var i = 0; i < emailAddresses.length; ++i)
  17.     {
  18.    
  19.       if (emailAddresses[i] == "")
  20.       {
  21.         //Do nothing..
  22.       }
  23.       else
  24.       {
  25.         validEmails.push(emailAddresses[i]);
  26.       };
  27.     };  
  28.     var bccs = validEmails.toString();
  29.    
  30.     Logger.log(bccs);
  31.    
  32.    
  33.     MailApp.sendEmail
  34.     (senderEmail,emailSubject,emailMessage,
  35.       {
  36.         name: 'John',
  37.         bcc: bccs,
  38.         noReply: true
  39.       }
  40.     );
  41.    
  42.     Browser.msgBox('Emails are on their way!')
  43.   }
  44.   else
  45.   {
  46.     Browser.msgBox('Emails have NOT been sent')
  47.   }  
  48.  
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement