How to create script to export PDFs from multiple records and then send email?

[Grom]

Hi all

I am trying to achieve a task in Filemaker 8 for a mac, and have spent hours trawling this forum for answers but no avail!

I have a database with two fields, name and email address. I want to export each record as a PDF, naming each PDF from the name field as a seperate PDF, into a folder called invite on my desktop. Then attaching each PDF to an email generated by the email address in the record. Is this something that can be done? Am new to more advanced scripting so has me stumped.

Any help would be amazing.

Thanks!

Graham

[bcooney]

I think that this demo will help. In it, I save the invoice as a pdf, but not into a folder on the desktop, but rather into the temp folder (which'll be deleted by the OS).

Take a look at the demo and come back with questions.

http://fmforums.com/forum/showpost.php?post/320960/

[Grom]

Thats fantastic! Cheers, that works in so far as it will generate an email for each record as I scroll through the, so one at a time. Is there a way to do 'multiple emails', i.e. so it generates a email for every record, but with its own unique PDF, when I tried it it just attached the same PDF to each email?

Thanks again, and if worst comes to worst I can do them one by one

Appreciate all your help

Ta

Graham

[bcooney]

Glad to help. To process a list, you'd wrap this with a loop.

For example, find all the people that you wish to email. At the top of the list view, put a button "Email List." This button runs the script:

Go to Record First

Loop

Perform script Email

Go to Next Rec, Exit after Last

End Loop

[Grom]

That works an absolute treat! Amazing, you have saved me so much time.

Thanks again, really really appreciate it!

Graham