WIth FileMaker Server, the file is always open unless you close it. A server schedule could run the script, but the export has to be done to a very specific location on the server and it wouldn't use Outlook for sending the email, you have to use the SMTP server option to send out the email.
You also have the option of setting up a FileMaker "robot file" that is opened at a set time via an OS based scheduling utility such as Windows Scheduled Tasks. You set up this robot file to perform a script automatically when it is opened. This script can use Perform Script to perform the script on the hosted file. This would then allow you to use Send Mail with the email client option to send out the email using Outlook.
But I don't know what settings you can change to make outlook do this without popping up a dialog box.
The current stumbling block is getting past Outlook and the security prompt. I was hoping that the program would have an option to turn this off.
Currently, you have to answer to ALLOW USER. I would prefer to go around OUTLOOK completely. I will pass the SMTP option over to our developer. Thanks.
Could you better explain what you mean by this?
" You set up this robot file to perform a script automatically when it is opened."
In File Options, you can specify that a script be performed "onFirstWindowOpen". This then causes a script to be performed each time you open that file. The scheduling utility simply opens the file, then this script trigger kicks in to perform a script that, in turn, performs a script in your hosted file.
Plugins can be used to avoid the security message in Outlook, one such is
This is an old email plugin comparison
Thank you, Phil!