Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function main() {
- var ui = SpreadsheetApp.getUi();
- var okienko = ui.prompt('Okno', 'Podaj tresc maila', ui.ButtonSet.OK_CANCEL);
- var wiadomosc = okienko.getResponseText();
- var akceptacja = okienko.getSelectedButton();
- if (akceptacja != ui.Button.OK)
- {
- ui.alert('Anulowales wysylanie wiadomosci');
- }
- else
- {
- var n = 8;
- var arkusz = SpreadsheetApp.getActiveSheet();
- var zakres = arkusz.getRange(2, 2, n, 1);
- var data = zakres.getValues();
- var temat = "Temat wiadomosci";
- for (i in data)
- {
- var wiersz = data[i];
- var address = wiersz[0];
- GmailApp.sendEmail(address, temat, wiadomosc);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement