How to schedule an email with Excel output of records from a table records in FMS?

[daleallyn]

@bdbd

In FileMaker Pro, the temporary folder and any files placed in it are deleted when FileMaker Pro is exited or quit. In server-side scripts, each script runs in its own session; once the script is completed, the session terminates and the temporary folder is deleted.

Great input above, and I'll just add this comment: For this kind of task, I typically use Get (TemporaryPath) instead of Get (DocumentsPath) unless one wishes to retain a copy every week in the server's documents directory. If, in the event I do wish to retain a copy of the exported Excel file, my preference is to store it in a container field in the database so it can be easily retrieved for review or whatever. It just depends on one's preferences and use case.