Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Filemaker  »  Automating emails with attachments...
Page 1 of 1    

Automating emails with attachments...
Author Message
Smurf...
Posted: Mon Oct 05, 2009 10:53 pm
Guest
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
Back to top  
Your Name...
Posted: Tue Oct 06, 2009 5:15 am
Guest
"Smurf" <wearesmurfs at (no spam) yahoo.ca> wrote in message
news:3655970d-9277-40f9-bd7a-9f575f3b3822 at (no spam) l31g2000vbp.googlegroups.com...
Quote:
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?

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 Surprised)
Back to top  
Smurf...
Posted: Wed Oct 07, 2009 3:41 pm
Guest
On Oct 5, 6:18 pm, "Your Name" <your.n... at (no spam) isp.com> wrote:
Quote:
"Smurf" <wearesmu... at (no spam) yahoo.ca> wrote in message

news:3655970d-9277-40f9-bd7a-9f575f3b3822 at (no spam) l31g2000vbp.googlegroups.com...





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?

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   Surprised)

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
Back to top  
Your Name...
Posted: Thu Oct 08, 2009 12:17 am
Guest
"Smurf" <wearesmurfs at (no spam) yahoo.ca> wrote in message
news:a92ed554-5c22-491e-984a-98453aad0bd9 at (no spam) z34g2000vbl.googlegroups.com...
On Oct 5, 6:18 pm, "Your Name" <your.n... at (no spam) isp.com> wrote:
Quote:
"Smurf" <wearesmu... at (no spam) yahoo.ca> wrote in message

news:3655970d-9277-40f9-bd7a-9f575f3b3822 at (no spam) l31g2000vbp.googlegroups.com...

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?

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

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

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 Surprised)
Back to top  
jahn...
Posted: Fri Oct 09, 2009 1:27 am
Guest
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.
Back to top  
Your Name...
Posted: Fri Oct 09, 2009 9:19 am
Guest
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). Surprised(

Helpfull Harry Surprised)
Back to top  
 
    Display posts from previous:  
Page 1 of 1    
All times are GMT
The time now is Fri Nov 27, 2009 4:47 pm
Computers Forum Index
 

Powered by phpBB & ML | Privacy Policy / Disclaimer



Contact Us