Attaching externally stored container field documents to email in scheduled script

Discussion created by vaguiar on Oct 18, 2017
Latest reply on Oct 23, 2017 by vaguiar

I have searched but found no solution.


Users can upload supporting documentation to mileage forms in container fields on a locally hosted Windows Server 2012 FM server. The base directory, therefore, is unalterable. Open storage is at:


"Mileage/" & staffer & "/Form#" & form_id & "/document1/"


It ends up on the server machine at a place like:


F:\Program Files\FileMaker\FileMaker Server\Data\Databases\RC_Data_FMS\PowerStation\Files\PowerStation\Mileage\Alejandra Solorio\Form#2414\document1


I'm trying to send an email with that document attached by using a calculated variable file path, such as:


"filewin:\\\F:\Program Files\FileMaker\FileMaker Server\Data\Databases\RC_Data_FMS\PowerStation\Files\PowerStation\Mileage\\" &


Staff::staffer & "\\" & Mileage Forms::form_id & "document1\\" &



GetContainerAttribute ( Mileage Forms::file1 ; "filename" )


I have tried many different variations with backslashes and forward slashes, and a share name for the documents folder, never successfully getting the doc to attach.


Any body know what to do? That would be fantastic. -- Victor