The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I want to write a macro to schedule and send a report automatically.
Can someone please help?
Macros execute when you visit the page they are on - they're not suitable for scheduling or sending reports.
It would be better to write a macro that provides the report you want and then ask the user to visit the page(s) you put it on.