Send Mail - Attach based on data

[crazybake]

I created a script that creates a .PDF file in a specific location using a variable ($FilePath) to the file path:
"filemac:/Macintosh HD/Users/me/Documents/Letters/" & "You_" & List::CourseFaculty & "_" & List::CourseQtr & List::CourseYear & ".pdf"

This works fine and the PDF is created in the location specified. However, I am trying to figure out a way to script the Send Mail step (at a later date) to go to the $FilePath and attach the file created based on the employee name (same as above). I tried to simply list the variable $FilePath in the attach > file path, but with no luck

 

[Agnes Riley]

Have you tried making your variable global? 

$$FilePath I stead of $FilePath? Just don't forget to clear the global variable when you don't need it anymore.

[crazybake]

Yes, but the same result. It may be a system issue. Even when I put in a direct path to an existing file, it appears to stall: It will add the recipients, but not the subject or message (or the attachment). If I uncheck the attachment box and run again, it will contain the subject and message.

Edited August 30, 2016 by crazybake
reran without attachment checkbox

[Agnes Riley]

That does not sound normal.

Are you running the script on a desktop or the server?

Also, do you have any plug-ins that could interfere?

[crazybake]

Just on the desktop and with no plug-ins. I am using Send Mail with a desktop client (not specifying the SMTP server) with Outlook 2016 and have not checked to see if there are any issues.

[Agnes Riley]

Outlook might be the culprit. I recommend using an SMTP server if you can. Do a little Google search on Outlook and FM. Here's one link that might (might not) help: http://help.filemaker.com/app/answers/detail/a_id/15190/kw/send email outlook

[Ted S]

Is this running on a Mac or a Windows machine?

[Lee Smith]

If you look at the profiles (left) it reveals that all off the posters are on a Macintosh, why?

[Ted S]

Probably because the developer is on a Mac but that doesn't mean that the problem is happening on a Mac.  Also, Outlook is mentioned and Outlook is far more popular on Windows which makes me ask for clarification.

[Lee Smith]

2 hours ago, Ted S said:

Outlook is far more popular on Windows which makes me ask for clarification

Outlook and FileMaker do not always play well together. Did your read the link posted by Agnes Riley?

[Ted S]

1 hour ago, Lee Smith said:

Outlook and FileMaker do not always play well together. Did your read the link posted by Agnes Riley?

I did. In fact I experience the Outlook 32 bit vs 64 bit problem first-hand which is why I asked whether this is happening on Windows or Mac.

The author's original post suggests that it is a Mac problem (filemac:Macintosh...) but it doesn't hurt to confirm. Maybe he doesn't realize that Windows and Mac use a different syntax.