title: Programmatically export a SharePoint Online list Daily
body: <p>I've been doing SharePoint for a few years now and this seemingly simple task has me stumped. I would like to automate the export of a list so that it runs at the end of each day and emails the report to me. This is in O365 so I can't just plop some PowerShell on the server, call it from bat file in Task Scheduler and be done. </p>
  
  <p>I've seen people mention building out .aspx pages and use Javascript/REST to generate the report, which is fine, but I don't know how to then automatically email that off each day.  </p>
  
  <p>I've played around with SharePoint Online Management Shell but don't know how to pull the list data in.</p>
  
  <p>Can someone point me in the right direction? Thanks!</p>