1 2 Previous Next 23 Replies Latest reply on Jul 18, 2017 12:03 PM by philmodjunk

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

    xxx202xxx

      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}

      Loop

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

            Go to Record [Next; Exit after Last]

      End Loop

       

      Send Mail [xxxxxxx]

        1 2 Previous Next