I am trying to open a Microsoft Excel Template on our server using a script. The script sorts the records and exports them to a .mer file. The scrip then uses the send message step to open a Microsoft Excel template, which contains a macro to import the data from the .mer file. If I run FileMaker on my machine with the template and .mer file also local the script works beautifully. However when I place the files on our server the script does not find the template file. If I change the send message step from either machine on the network the script will find the file from only that machine (as expected).

I have also tried the open URL step with a slightly different result. It finds the file (I know this because I have a show message step at the end that executes) but does not open the file either on the client machine or on the server.

The remote volume needs to be mounted (logged-in) on the guest computer.

Yes of course. I mapped a network drive to the folder containing the template file and used the same drive letter on all machines and it works wonderfully. Thank You.