Can Filemaker TURN ON at specified Time, email thru Outlook unstopped by Prompts?
We are working on a project that the user has requested the following:
1) 2:00am a script runs to turn on FMP12 and the Specific db
2) The db does a Search
3) The Search search results are saved as a CSV file and
4) emailed through OUTLOOK to a set group of managers
5) It all has to happen without human intervention and it has to run every day at the set time.
The Challenge so far is:
Outlook on the Server has PROMPT windows. ALLOW DENY CANCEL.
Can the Filemaker db be turned on with a script at a set time?
Does FMP12 Server do this or do we need to write something in Visual Basic or the like? If so, what is best?
Can the Outlook prompts be turned off so as to not hinder the email function in any way?
Is there another way around Outlook completely such that this is all done in Filemaker?
Any help, experiences, etc greatly appreciated.