title: Google Sheets Script MailApp.sendEmail prompt
body: <p>Trying to alter the following script to prompt for an email address.  I was able to load this as an add-on in Google sheets and it works fine but I want to be able to change the "To" address each time I run it. Is there any way to force some sort of prompt so that I can input the email address on each run?</p>
  
  <pre><code>    function onOpen() { 
    // Try New Google Sheets method
    try{
      var ui = SpreadsheetApp.getUi();
      ui.createMenu('SendMail')
      .addItem('Send Report', 'getGoogleSpreadsheetAsExcel')
      .addToUi(); 
    }
  
    // Log the error
    catch (e){Logger.log(e)}
  
  }
  
  function getGoogleSpreadsheetAsExcel(){
  
    try {
  
      var ss = SpreadsheetApp.getActive();
  
      var url = "https://docs.google.com/feeds/download/spreadsheets/Export?key=" + ss.getId() + "&amp;exportFormat=csv";
  
      var params = {
        method      : "get",
        headers     : {"Authorization": "Bearer " + ScriptApp.getOAuthToken()},
        muteHttpExceptions: true
      };
  
      var blob = UrlFetchApp.fetch(url, params).getBlob();
  
      blob.setName(ss.getName() + ".csv");
  
      MailApp.sendEmail("xxxxxx@gmail.com", "Stock report of today", "The XLSX file is attached", {attachments: [blob]});
  
    } catch (f) {
      Logger.log(f.toString());
    }
  }
  </code></pre>