I have a query which I can run and collect all the topics which have not been marked as solved (unresolved) within the past month. Does anyone know how I can automate this to happen every week and then send the list of queries directly to an email inbox as a notification?

Maybe have a look at this: Automatically email admin report CSVs on a recurring cadence - #3 by sam

自动运行一个查询未解决的帖子并将结果作为电子邮件发送

pfaffman (Jay Pfaffman) 2023年六月7日 14:30 2

話題		回覆	觀看
Identifying posts that haven't been resolved automatically Support	1	584	2023年六月10日
Triggering alerts when topic not solved/handled/replied Feature	2	1047	2017年八月28日
How to generate tailored email or message when problem Solved Support	1	394	2023年五月16日
Automatically email admin report CSVs on a recurring cadence Feature email	10	1405	2023年六月8日
Notify a question's author with request to choose and mark a solution Feature solved	9	4478	2020年五月7日