We have a script that will pull records of a find and then export them to an .xlsx file on the FileMaker server. Cannot find a way to then email that file via SMTP from the server in a script step using a server-side schedule.

Script below:

Perform Find (Restore)

Set Variable [$path; Value: "filemac:" & Get (DocumentsPath) & "export.xlsx"]

Export Records {No dialog; "$path"; Unicode (UTF-16)]

Show all records

This script successfully exports the found records to the default store on the server, now how to email this as an attachment?

Use the send mail script step and put $path as the attachment.

When running the schedule on the server, I get an event report emailed, but no attachment. Do I need to put the SMTP details into the send script step or just have the details in the server schedule?

Its strange that you can set an email schedule on the server but not have the ability to add an attachment.

I've never used the email schedule on the server.. try putting the smtp deets in the send script. Then just run the script as a scheduled script and not an email schedule.