Every week I need to do a report by user on how many times they accessed their mailbox and from what IPs. It's a bit tedious. Is there any way to automate this in the Security and Compliance interface? Either for download or have it e-mailed?
There is a "schedule report" functionality in O365, however it only covers some of the reports and the ones you are after are not included. So the best option here will be to custom create a program/script that fetches them and emails them to you, as Juan suggested. Or, use third party reporting tools that offer scheduling functionality across the board.