Mail attachments from content of container-field?
is it possible to use the content of a container-field as a mail attachment? (.pdf or word.doc ...).
The container-field is in the same record of the mail-field.
Try a script that uses a variable to specifiy the path to the file:
Set Variable [ $_attachment ; GetValue ( GetAsText ( your_container_field ) ; 2 )
Send Mail // open this script step and type $_attachment as the file path
Nick's method works if the file was Inserted "by reference". Your screen shot suggests that you may have inserted an actual copy of the file.
In that case, you would need to use "export field contents" to export a copy of the file before you could attach it. There are ways to script this with a variable that exports the file to the temporary items folder so that the file can then be attached to the email by the send mail script step.
thank u for the suggestions, but i must doing somthing wrong.
in Filemaker Pro 11, there are some example files included. Ik used the 'mail-campaign' this example contains the function that i need.
But in don't work. If i send it by mail, for the attachement there is only the name of the specified file at the bottom of the mail, but not the file itself.
Are the files "store by reference" or is the actual file stored in the container field?
What does your actual script for doing this look like?
they are actual stored in to the file. If you are intrested in the code, i uploaded the file on a server:
If you read the first post I made to this thread, I indicated that if the files were not stored by reference Nick's script, as written, wouldn't work. You'll need to first use Export Field Contents to export the file, then you can attach it and email it.
Set Variable [$Path ; Get ( TemporaryPath ) & "FileName.PDF" ]Export Field Contents [YourTable::ContainerField ; $Path ]Send Mail [Send via email client; To: Emailaddfield ; Subject: "Requested File" ; Message: "Message text" ; "$Path"]
Retrieving data ...