No, it is not possible to automate the generation of reports using Custom Functions. However, you can utilize the feature Schedule Reports and configure the desired frequency in which you wish to generate reports and send them to your recipients automatically.
Books
Online accounting software
for small businesses.