Jump to content
Sign in to follow this  
Forum Joe

Script to send email with contents from various fields

Recommended Posts

Ok, I need to setup a script that will send an email (always to the same person) a list that is generated from my FM Pro database.

So I have it set to do a find matching records, and usually there'll be 10 or so records. I need filemaker to export two fields from each record (Name and Address, for example) and put that list into an email. Can this be done within a filemaker script, or is a more complex applescript required?

I'll also want this script to run automatically at 9:00 on a monday morning.

Share this post


Link to post
Share on other sites

Is the final result one email with a list of Names and Addresses?

If so, I'd do a looping script on the found set that builds a global text field and put that global in as the email body, and use Send Mail script step.

There's a plugin that'll allow for scheduled scripting (troi).

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.