FMP 8 on Mac OSX4.9
Volunteer DB is used on PCs and working well.
Users want to send out thank you's or donation requests.

DB has the following:
Table 1 Volunteers with multiple fields of personal data and a nice
little find-selected-volunteers script.
Table 2 Form Letters with 2 fields - Title and Body

Object - to select a form letter body by title, with the option to
modify it and save it under a new title as a new record in the Form
Letters table, then send a form letter that is made up of merge fields
for name, adress, etc. with the chosen body, to the selected
volunteers.

So far I choose the selected volunteers, then go to a "Compose" layout
where I select the title from a drop-down list and the corresponding
body appears in an editable text box. Next I go to a layout with the
printable version.

Problem - I get the right number of letters with the right volunteers,
but only the first record (first selected volunteer) has the chosen
body. The next ones have the other bodies from the Form Letter table.

Thanks for help with this

In article <1176787453.618261.220160 (AT) o5g2000hsb (DOT) googlegroups.com>,
CRC123 <swanson (AT) windsongappraisals (DOT) com> wrote:

Just a guess since you don't say how choosing a Title obtains the
correct letter, but the Title field (in the Volunteers table) should
probably be a Global field so that it affects ALL records rather than
just the current one.

If the Title field (in the Volunteers table) is just a normal, then
picking a new Title from the drop-down list will only change the
current record ... all the other records will still have whatever Title
they have saved from previous choices.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On Apr 16, 11:08 pm, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:
Thanks HH.
Sounds like a plan.
I will try that tonight after work and get back to you.

On Apr 17, 7:37 am, CRC123 <swan... (AT) windsongappraisals (DOT) com> wrote:
Worked like a charm. Tx