FM 8.5
I am trying to automate my Invoicing such that I can script a button
to create an email with a pdf of the current Invoice attached. This is
what I did. table INVOICES 2008 (has relationship with CONTACTS)

Print Setup
Save Record As PDF
specify output file = file:/Users/Matthew/Desktop/ Orders/ To
be delivered/ Invoices
specify options = Current Record
Send Mail
To: CONTACTS::Accounting_Contact_Email
Attach file: filemac:/Users/Matthew/Desktop/ Orders/ To be
delivered/ Invoices

It returns the error
"Invoices could not be created on this disk."

Perhaps my file paths are written wrong? The PDF path I mean to save
the pdf in a folder called Invoices. Attach file I mean to take me to
the file where pdf was saved.

Can you help?
Thanks
Matthew

"Smurf" <wearesmurfs (AT) yahoo (DOT) ca> wrote

It could just be a typo in posting the Script here, but the two filepaths
begin differently.

The first output file one says:
file:/Users

and the second says:
filemac:/Users


Helpfull Harry )

On Oct 5, 6:18*pm, "Your Name" <your.n... (AT) isp (DOT) com> wrote:
Yes, that is correct. When reading this scripting note on Filemaker I
am unclear what they are saying. Are they saying if Mac (I am), write,
filemac:/Users or file:/Users or /Users/... Perhaps you can clarify
this much for me.

Thanks

"Smurf" <wearesmurfs (AT) yahoo (DOT) ca> wrote

On Oct 5, 6:18 pm, "Your Name" <your.n... (AT) isp (DOT) com> wrote:
Usually I'm only using FileMaker 5.5 which doesn't have this, but by chance
I was trying to get a FileMaker 9 database to export to the Mac Desktop
yesterday.

From what I understand of the Help file ...

"file:" is used for locations that are relative to the database files

"filemac:" is used for locations with a full filepath

What you need to use is "filemac:" ... BUT you've also only got a partial
filepath there since you can't start with "Users". In the full filepath
there should at least be the drive name and possibly other folder names
before of that (I'm not using MacOS X here to check what it is).

I don't know if these are in FileMaker 8.5, but in yesterday's work with
FileMaker 9 I found the Get(DesktopPath) function which returns the filepath
to the current user's Desktop. This meant I was able to have the following
export Script:
Set Variable [$Path; Get(DesktopPath) & "MyFile.csv"]
Export [No Dialog; $Path]


Helpfull Harry )

Harry's got it right. I work on a Mac and always use the Get
(DesktopPath) function plus the name of the file I'm creating to set
the variable. Then I use the variable as the full path name. I don't
know if it's still the case with FM10, but when I was using FM 8.5,
the program used two different syntaxes depending on whether you were
getting a path or putting to a path. They may have straightened it
out since then. Better just to define a variable then hard code it.

-J.

There is of course and added problem here in that different email
applications behave differently to the Send Mail command ... but there's no
way around that (unless you want to write an AppleScript to create the
emails). (

Helpfull Harry )