trying to automate batch between FMP and mail

Scripting Forums Automator
#1

I’m sure this is simple (because it’s a Mac), but I am not quite sure how to fit the pieces together.

I have 34 records in a FileMaker database. Each record contains (among other things) a field containing an email address and a first name field.

I am trying to send a [pdf] copy of each person’s record by email for that person’s inspection.

I notice that in my print dialogue, under the button for PDF, there is an option to email PDF which is great if I can pass the email address and merge the first name & cover text into the mail message - before the pdf attachment.

Does that make sense? I see little bits of the puzzle in each part of the overall job, but I just don’t know how/where to attack the picture to pull it all together.

Can anyone offer any assistance?
Thank you,

Dee Dee (a mac veteran, novice scripter)

Model: MacBook
Browser: Safari 3.0.4
Operating System: Mac OS X (10.4)

#2

Hi deesquared,

This can all be done in FMP natively.

Steps:
–this will save the pdf to your desktop and then email
–you could attach a script that deleted the pdf’s after saving
–if you wanted them in a folder on your desktop add that after
–like: Get ( DesktopPath ) & “desktopFolder/File_name_here.pdf”
–FMP requires POSIX paths

Set Variable[$filePath; Value:Get ( DesktopPath ) & “File_name_here.pdf”]
Save Records as PDF [Restore; “$filePath”; Current record]
Send Mail[]

Under Send Mail[] you will need to specify the email field from your
db and the file to attach which will be $filePath.

If this is not clear let me know.

Craig