Make PDFs and use the "Append" option on the "Save Records as PDF" script step.

j.



On Aug 26, 2009, at 10:58 PM, Landy Atkinson wrote:

I have a need to send more than one attachment in an email created using the email script step in FMP 10. The step allows you to specify more than one file, but this just seems to provide multiple search paths and the first file found is the one attached. I have not figured out a way to tell it to include more than the first valid file it comes across.

Here is the need, in case someone has a good work around.

I use FMP 10 to create Return Material Authorization tracking numbers along with a record of all touches along the RMA process. The first step is to generate a 1 page document from the data entered in the initial call from a customer that includes a shipping label at the top and return instructions and a place to fill in payment information for a repair at the bottom. For international customer, there is an additional document required to deal with Customs and for a few products there is a special handling document we send. For 99% of our customers, these documents are sent as email attachments. The request from the database users is to have these documents automatically attached to the email as needed. I started out by adding a couple of check boxes that the person taking the RMA call can mark off if these additional documents are required. I thought it would be a simple matter to just create several email script steps with an if-then structure to decide which to use based on the check boxes. This won't work until I can figure out how to specify more than one attachment during the script step.

The only alternative I have come up with is to create 4 different layouts

1.  RMA Only
2.  RMA and Special Handling
3.  RMA and International
4.  RMA and International and Special Handling

and branch to those to create the attachment. For the international form, this would be a bit trick as the customs form is a bit complex.

Any other ideas?

-Landy


--
Jonathan Fletcher
FileMaker 9 & 10 Certified Developer
****NEW Ph no: 502-509-7137****

Project Foreman
NewMedia Construction Co.
[email protected]

Instigator
The BB&J Network
The "Go-To Guys" for
FileMaker Development in Louisville
www.thebbandj.net

FileMaker Louisville Blog:
http://filemakerlouisville.posterous.com

Reply via email to