Is this feasible in Filemaker?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sovageorge@gmail.com - 27 Aug 2008 16:29 GMT

I am using FM 9.3 to create a reference library for documents needed
in valuation of various financial assets. A table called Muni Bonds
has a field containing a URL of the document describing the bond in
detail. This document is in the PDF format, and could be anywhere from
5 to 100 pages. A button on the screen opens up the document if the
user needs to read the document

However, sometimes the user needs to email the entire document to a
third party for further opinion. I would like to email the document
using Send Mail script, but unfortunately the Attach File option in
the script does not allow to calculate the file path of the document
to be attached.

Is there some other way this could be accomplished? I was thinking
about a container, but am stumped.

Please help.

Reply to this Message

Martin Trautmann - 27 Aug 2008 16:50 GMT

> I am using FM 9.3 to create a reference library for documents needed
> in valuation of various financial assets. A table called Muni Bonds
[quoted text clipped - 11 lines]
> Is there some other way this could be accomplished? I was thinking
> about a container, but am stumped.

Personally, I would not recommend to send PDFs within mail, instead of
sending the URL instead.

On Mac you might use AppleScript and unix commands to handle this task.
Same should be possible for Win.

Just as an untested idea: create the file path for a container,
copy/paste the content for a copy within FMP, attach this content.

- Martin

Reply to this Message

Nicolay Flaaten - 27 Aug 2008 16:51 GMT

> I am using FM 9.3 to create a reference library for documents needed
> in valuation of various financial assets. A table called Muni Bonds
[quoted text clipped - 13 lines]
>
> Please help.

You can spesify a filepath as a variable $savedfile like this:
"file:" & Get ( DesktopPath )&Invoicenumber&".pdf"

When using the send mail script, you checks the attach file and writes
$savedfile

Then the saved file will be attached and sendt with the mail.

Nicolay

Reply to this Message