Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function sendEmailsToStaff()
- {
- if (Browser.msgBox('Are you sure you would like to continue?', Browser.Buttons.YES_NO) == 'yes')
- {
- var emailMessage = SpreadsheetApp.getActiveSheet().getRange("Statement Data Input!H5").getValue();
- var emailSubject = SpreadsheetApp.getActiveSheet().getRange("Statement Data Input!G5").getValue();
- var senderEmail = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Statement Data input").getRange("Statement Data input!D2").getValue();
- var senderName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Statement Data input").getRange("Statement Data input!C2").getValue();
- var emailAddresses = [SpreadsheetApp.getActiveSpreadsheet().getSheetByName("staff1").getRange("staff1!B5").getValue(),SpreadsheetApp.getActiveSpreadsheet().getSheetByName("staff2").getRange("staff2!B5").getValue()];
- var validEmails = [];
- for (var i = 0; i < emailAddresses.length; ++i)
- {
- if (emailAddresses[i] == "")
- {
- //Do nothing..
- }
- else
- {
- validEmails.push(emailAddresses[i]);
- };
- };
- var bccs = validEmails.toString();
- Logger.log(bccs);
- MailApp.sendEmail
- (senderEmail,emailSubject,emailMessage,
- {
- name: 'John',
- bcc: bccs,
- noReply: true
- }
- );
- Browser.msgBox('Emails are on their way!')
- }
- else
- {
- Browser.msgBox('Emails have NOT been sent')
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement