list in emails

[yeddaborg]

Hello,

I'm having a monday afternoon brain-lapse in conjunction with a lengthy amount of time away from FMP--not a good combo.

I wish to use the Send Mail script to send data from related records in a list format...e.g...

Patient ID, Date of Birth, Weight

101, 2/5/1991, 125

102, 10/1/1987, 143

103, 5/20/1969, 118

etc...

(cannot show tab "effect" on this post--so please assume that for every comma above, a tab would be in its place.)

The calcs I usually embed within Send Mail scripts usually only require info from one record at a time, so this is throwing me for a loop.

TIA for help on what I anticipate to be basic functionality that I should already know!

Regards,

Julia

Edited September 25, 2007 by Guest
Client being used is 8.5 Advanced--post will not reflect this edit. thanks.

[bcooney]

Who are you sending the emails to? That's the parent record of these patients, perhaps?

If so, create a calc field that concatenates the fields you need in your list (PatientID, DOB, Weight). Use this cf to add tabs, if you want. Then in the Send Mail body, use List (parent::calc field).

In the found set of parent records, loop thru with Send Mail.