Sending Reports

[Raymond Gonzalez]

Hello. I have a filemaker database where I make reports. Lets say that I want to send those reports to some users that are recorded in a "members" table in my database through email, how can i do that? Thanks

[bcooney]

Use the Save as PDF script step, and Send Email w/attachment script step.

[Raymond Gonzalez]

But how would i choose the members i want to send it too? im sorry but im not very good at this!

[bcooney]

Your script would:

1. Create the report and Save as PDF, and store the path in a global field or global variable.

2. Go to the Members table (list) and find the members that are to receive the report. This is either hardcoded Find in the script (let's say, for example, all "Active" members), or the user marks the members and their IDs are stored in a global text field.

3. If the members are manually marked as recipients, then the user clicks a Send Report button that sends the report as an attachment to the members email addresses in the found set.

So, do you need a customized email or can each member receive the exact same email? Do you need to manually mark the members that will receive the email or can you script a find?