AnsweredAssumed Answered

How to send an email with data from one field from multiple records?

Question asked by xxx202xxx on Jul 12, 2017
Latest reply on Jul 18, 2017 by philmodjunk

I am attempting to send a notification email where the body of the email consist of various fields but the note field will need to come from multiple records. The email is sent but with only 1 record from the notes field even though 5 records are in the found set.  How would I set up the body of the email so that all 5 records in the found set will be grouped and sent or just sent period.


My script is as follows:


Go to Related Record [From Table: "Note Management"; Using "Note Layout (Note Management)]

Go to Record [First}


      Set Variable [$List; Value: List ( $List; Note Mangement::NoteField)]

      Go to Record [Next; Exit after Last]

End Loop


Send Mail [xxxxxxx]