I'm afraid I don't know enough about scripts to know how to adapt this to my needs. Do I have to generate a pfd to do this or can FileMaker create a text email from the layout text and field text?
If you want to create a formatted email (Looking like your layout) then a PDF of the layout is needed.
You can create an text email with fields, but you cannot format the data like your printouts.
For a manual process, goto File--> Save/send records as PDF, then use the attach PDF to email option.
Thank you. Can I automate this with a script so that if I have 50 records in my found group, it will make 50 pdfs and email each record to the individual it's supposed to go to? I have an email field.
Reduced instruction from the script I referenced from ORLANDO :
This is the jist...but I haven't tried it....
Do your find, then make a script to execute the following--->
Set Error Capture [ On ]
Go to Record/Request/Page [ First ]
Set Variable [ $ActiveEmail ; YourTable::Email ]
Go to Layout [ YourLayout ]
Set Variable [$FilePath ; "filemac:" & Get ( TemporaryPath ) & "Report.pdf"]Go to Layout [ YourLayout ]
Save Record as PDF [ No dialog ; "$FilePath" , Current record ]
# PDF has been created, now attach and send in email
Send Mail [ To:$ActiveEmail ; subject: "Report" ; "$FilePath" ]
Go to Record/Request/Page [ Next ; Exit after last ]
When you get this working...you may want to add a scripted FIND to the process.