SQL HTML Outlook workflow formatting issue

• Postit9

  Newbie

  Points: 8

  More actions

  September 21, 2018 at 2:13 pm

  #408485

  Hi there,
  I'm hoping to get some help on an SQL, HTML, Outlook 2013 issue. I have a workflow in my sql database, when the value of the "Status" field is "Agree" then I want it to pull other data from that record and put it in an email. This works fine but the issue is with the format of the resulting email. I need to add a line break between each of the values pulled. I have tried </br>, </P> etc but nothing has worked correctly. I'm not even sure what this type of code is in the workflow below so wasn't sure where to post this question. Any help greatly appreciated. I don't have a developer background so layman's terms would be great. Thanks!

  Workflow
  tr_status_change: trigger
  Operation      <- 'propertychange'
  Entity             <- 'Opportunity'
  Property        <- 'Ref_Status'
  ValueId          <- '9d6279b0-f280-4dd6-42a0-a709d8a08166'
   
  fetch
      Entity <- 'Opportunity'
      Internal ID <- tr_status_change.EntityKey
   
  subject_txt: concat
     Template <- 'AGREE - {0}'
     0 <- fetch.Investor
   
  Body: concat
   Template <- 'COMPANY:  {1},   FAMILY:  {2},   CONTACT:  {3}, TARGET NAME:  {0}, EXISTING/NEW:  {4}, AMOUNT:  {5}'  
                      
    0 <- fetch.Name
    1 <- fetch.Investor
    2 <- fetch.Family 
    3 <- fetch.Contact(Co)
    4 <- fetch.ExistingorNew
    5 <- fetch.Amount
   
   ---------------------------------------------------------------------
  Shows as
  COMPANY:  Test 6/11/18,   FAMILY: Rabbit,   CONTACT: Jessica Rabbit, TARGET NAME:  Test 6/11/18 EXISTING OR NEW:  New, AMOUNT:  30.00000000
  -----------------------------------------------------------------------
  Want it to show as
  COMPANY: Test 6/11/18
  FAMILY: Rabbit
  CONTACT: Jessica Rabbit
  TARGET NAME: Test 6/11/18
  EXISTING OR NEW: New
  AMOUNT: 30 (how can I format AMOUNT to $30 instead of 30.000000 ?)