2 Replies Latest reply on Feb 14, 2014 8:04 AM by DavidKinally

    Multiple related records in the "Send Mail" function

    DavidKinally

      Title

      Multiple related records in the "Send Mail" function

      Post

           Hi There,

            

           I have the Send Mail function set up to send an order through to an email address as part of a purchase order system i am trying to create. The only issue is i have on my table a Portal to "Order Items" . This way in a single purchase order you can add multiple order items.

            

           What i want to do now is email that purchase order info by pressing a button which runs a "Send Mail" script. The only issue is that only the first item shows in the email.

           Is there a way for this email to generate all the Related Items into a list?

           I have attached a screen shot. Thanks

                      
                     Preferences
      §
      1
      2
      3
      4
      5
      6
      7
      8
      9
      0
      -
      =
      Backspace
                           
      Tab
      q
      w
      e
      r
      t
      y
      u
      i
      o
      p
      [
      ]
                                
      Return
                                
                           
      capslock
      a
      s
      d
      f
      g
      h
      j
      k
      l
      ;
      '
      \
                           
      shift
      `
      z
      x
      c
      v
      b
      n
      m
      ,
      .
      /
      shift
                           
                                
                               English
                                     
                                     
      alt
      alt
                           
                      
                     Preferences

            

      Screen_Shot_2014-02-12_at_13.56.41.png

        • 1. Re: Multiple related records in the "Send Mail" function
          philmodjunk

               Use either:

               List ( OrderItems::Items )

               or

               Substitute ( List ( OrderItems::Items ) ; ¶ ; ", " )

               The first produces a vertical list of items in the body of your email, the second produces a horizontal list.

          • 2. Re: Multiple related records in the "Send Mail" function
            DavidKinally

                 Amazing phil.... as always

                            
                           Preferences
            §
            1
            2
            3
            4
            5
            6
            7
            8
            9
            0
            -
            =
            Backspace
                                 
            Tab
            q
            w
            e
            r
            t
            y
            u
            i
            o
            p
            [
            ]
                                      
            Return
                                      
                                 
            capslock
            a
            s
            d
            f
            g
            h
            j
            k
            l
            ;
            '
            \
                                 
            shift
            `
            z
            x
            c
            v
            b
            n
            m
            ,
            .
            /
            shift
                                 
                                      
                                     English
                                           
                                           
            alt
            alt
                                 
                            
                           Preferences