7 Replies Latest reply on Jul 24, 2012 1:56 PM by Corey Hinman

    Using dispatch to send outlook messages by data card variable <-solution

    Corey Hinman

      Ok, so I've been looking for something a bit more friendly than dynamic notifications. Sometimes you just have to do things yourself

       

      I want to set users for specific tasks and then have enterprise send emails to those people without doing it through workflows (which I've done in the past). In this example it's a button on the data card, but I plan to send the emails once the files pass through a transition.

       

      I'm not a programmer, I don't know how to use the API, but this is what I came up with. I'm looking for feedback and maybe some ways to improve upon this.

       

      • First, the data card needs to have the variables for said tasks, I used the user login name for the list, which matches our windows user names, and also outlook.

      dispatch_datacard_1.JPG

      • Second, create 2 files in the vault
        • File #1: email_template.txt
          • This file will be used by dispatch to output a command line prompt that includes variable values.
          • "C:\Program Files (x86)\Microsoft Office\OFFICE14\OUTLOOK.EXE" /c ipm.note /m "%ECO Val owner DFMEA%;%ECO Val owner Cust App%;%ECO Val owner DVPR%;%ECO Val owner CWO%;%ECO Val owner Risk%;%ECO Val owner Gage%;%ECO Val owner Times%?do=newpm&u=&subject=You have open Tasks in ECRxxxx"

          • This looks like a lot but it breaks down like this.....
            • enter the path to your outlook

              • "C:\Program Files (x86)\Microsoft Office\OFFICE14\OUTLOOK.EXE"

            • Add the following arguments:

              • /c ipm.note /m

            • Add the variables (usernames) separated by ; <this becomes TO data>

              • "%ECO Val owner DFMEA%;%ECO Val owner Cust App%;%ECO Val owner DVPR%;%ECO Val owner CWO%;%ECO Val owner Risk%;%ECO Val owner Gage%;%ECO Val owner Times%

            • End with the following:

              • ?do=newpm&u=&subject=You have open Tasks in ECRxxxx"

       

        • File #2: tasks_email.bat
          • This is the parameter file that Dispatch will Create.
      • Dispatch Setup
        dispatch email.JPG

       

                dispatch email2.JPG

               

      outlook_results.JPG

       

      Hope others find this helpful!

       

      Thanks,

      Corey Hinman

      CEPA, CSWP

      http://www.epdmblackbelt.blogspot.com/