With filemaker 11, email can be sent from an IWP database using an SMTP email server.
We have Server 10 advanced. Can you run a 11 database on server 10?
OK, so here is what I did......
Created a server schedule that creates a export file every hour, http://forum-en.filemaker.com/t5/Using-FileMaker-Pro/exporting-file-with-scheduled-server-script/m-p/71229g, and saves the export in the documents folder on the server and captures the file name in a field in a export table.
I created an email table. when the user clicks the email report button, a new record is created in the email table. User enters the email address they want the report sent to.
Another server schedule runs every 15 minutes and checks if there are any new records in the email table that have no "email sent time stamp. If there are, it goes to the last record in the export table and sets the file name as a variable and then loops thru the records and sends mail thru SMTP (ONLY available as a possability with IWP in FM11) attaching the variable filename to the email. Marks the record with the current time stamp to show completed.
All this was programmed in FM11 but runs fine on a FMS 10.
Thanks for all the help from everyone!!!!