5 Replies Latest reply on Sep 6, 2016 6:33 AM by Johan Hedman

    Emailing one record

    nathanrewbury

      I have created a contacts database from a starter solution and have begin to fill in records of our clients. The idea of the contacts database is to be able to send contacts details via email and this is functioning, but when the email is sent it sends all of the records in the database. Can someone tell me how I can send 1 single selected record?

        • 1. Re: Emailing one record
          PeterWindle

          it's an option in the send mail script step

          • 2. Re: Emailing one record
            nathanrewbury

            I currently have this. What changes do I need to make?

             

            Mail Script.tiff

            This is under the 'Message' Section of No. 5:

            Let (

              [

              title = Contacts::Title ;

              name = Contacts::Name for Labels ;

              company = Contacts::Company ;

              job = Contacts::Job Title ;

              web = Contacts::Website ;

              phone = Contacts::Office Phone ;

                    mobile    = Contacts::Mobile ;

              fax = Contacts::Fax ;

              email = Contacts::Office Email ;

              address1 = Contacts::Work Address 1 ;

              address2 = Contacts::Work Address 2 ;

              city = Contacts::${Work City/Town} ;

              state = Contacts::Work County ;

              postal = Contacts::Work Postal Code ;

              country = Contacts::Work Country

              ] ;

             

              If ( not IsEmpty ( title ) ; "Name: " & title & " " ; "" )  & 

              If ( not IsEmpty ( name ) ; name & "¶¶" ; "" )  & 

             

              If ( not IsEmpty ( company ) ; "Company: " & company & " - " ; "" )  & 

              If ( not IsEmpty ( job ) ; job & "¶¶" ; "" )  & 

             

              If ( not IsEmpty ( web ) ; "Website: " & web & "¶¶" ; "" )  & 

             

              If ( not IsEmpty ( phone ) ; "Phone: " & phone & ¶ ; "" )  & 

                            If ( not IsEmpty ( mobile ) ; "Mobile: " & mobile & ¶ ; "" )  &

              If ( not IsEmpty ( fax ) ; "Fax: " & fax & "¶¶" ; "" )  & 

              If ( not IsEmpty ( email ) ; "Email: " & email & "¶¶" ; "" )  & 

             

              If ( not IsEmpty ( Contacts::Work Address Short ) ; "Work address:¶" &

              If ( not IsEmpty ( address1 ) ; address1 & ¶ ; "" )  & 

              If ( not IsEmpty ( address2 ) ; address2 & ¶ ; "" )  &

              If ( not IsEmpty ( City ) ; City & ", " ; "" )  & 

              If ( not IsEmpty ( State ) ; State & " " ; "" )  & 

              If ( not IsEmpty ( postal ) ; postal & ¶ ; "" )  &

              If ( not IsEmpty ( Country ) ; Country & "¶¶" ; "" ) ;

              "" )

             

              )

            • 3. Re: Emailing one record
              Johan Hedman

              You need this to use this Script Step and choose "One email using data from current record"

               

              Unknown.jpeg

              1 of 1 people found this helpful
              • 4. Re: Emailing one record
                nathanrewbury

                But then how do I assign this script to a button?

                • 5. Re: Emailing one record
                  Johan Hedman

                  You can choose to just do one Script step from a button or do a Script from a button. Right click on your button and then choose Button

                  1 of 1 people found this helpful