https://www.high5software.com//mediawiki/index.php?action=history&feed=atom&title=Automated_Email_Installation Automated Email Installation - Revision history 2026-05-04T20:53:28Z Revision history for this page on the wiki MediaWiki 1.35.11 https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=6143&oldid=prev DavidH: /* Modifying outbound looks and information Emails */ 2016-07-26T17:53:04Z <p><span dir="auto"><span class="autocomment">Modifying outbound looks and information Emails</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:53, 26 July 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l91" >Line 91:</td> <td colspan="2" class="diff-lineno">Line 91:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(<del class="diffchange diffchange-inline">20</del>)) + &#039;] <del class="diffchange diffchange-inline">for </del>: &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +<del class="diffchange diffchange-inline">isnull(</del>a.<del class="diffchange diffchange-inline">AddressBlock</del>, &#039;<del class="diffchange diffchange-inline">&#039;) </del>+ &#039;&lt;br&gt;&#039; +&#039;<del class="diffchange diffchange-inline">Company Name Service Order </del>&#039; <del class="diffchange diffchange-inline"> </del>+ <del class="diffchange diffchange-inline"> cast(</del>a.<del class="diffchange diffchange-inline">DateTimeIn as varchar(100)) </del>+ &#039; <del class="diffchange diffchange-inline">    has been </del>&#039; +<del class="diffchange diffchange-inline">isnull( </del>a.<del class="diffchange diffchange-inline">OrderStatus,</del>&#039;&#039;<del class="diffchange diffchange-inline">) </del>+ <del class="diffchange diffchange-inline">&#039;</del>.<del class="diffchange diffchange-inline">&#039;  </del>+ &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">(case when a.BillingStatUID = &#039;void&#039; then &#039;Order VOID&#039; </ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#039;<del class="diffchange diffchange-inline">Priority Level</del>:&#039; <del class="diffchange diffchange-inline">  </del>+isnull<del class="diffchange diffchange-inline">(cast</del>(a.<del class="diffchange diffchange-inline">Priority as varchar(20))</del>,&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;<del class="diffchange diffchange-inline">Summary</del>:&#039; +isnull(<del class="diffchange diffchange-inline">a</del>.<del class="diffchange diffchange-inline">Summary</del>, &#039;<del class="diffchange diffchange-inline">Summary</del>&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">            else (case when isnull(a.OrderStatus, &#039;&#039;) = &#039;&#039; then &#039;Order Open&#039; </ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#039;<del class="diffchange diffchange-inline">Contract type</del>:&#039; <del class="diffchange diffchange-inline">  </del>+<del class="diffchange diffchange-inline">isnull</del>(a.<del class="diffchange diffchange-inline">SLACategory</del>, &#039;<del class="diffchange diffchange-inline">FSMA or E&amp;L</del>&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order <del class="diffchange diffchange-inline">number </del>: &#039;+isnull(cast(a.<del class="diffchange diffchange-inline">RefNum </del>as varchar(<del class="diffchange diffchange-inline">20</del>)),&#039;&#039;) +&#039; <del class="diffchange diffchange-inline">  Technician assigned</del>: &#039; + isnull(a.<del class="diffchange diffchange-inline">AssignedTo</del>, &#039;<del class="diffchange diffchange-inline">Nobody</del>&#039;) + <del class="diffchange diffchange-inline">&#039;.&#039;  </del>+ &#039;&lt;br<del class="diffchange diffchange-inline">&gt;&lt;br</del>&gt;&#039; +&#039;<del class="diffchange diffchange-inline">Site contact</del>: &#039; + <del class="diffchange diffchange-inline">b</del>.<del class="diffchange diffchange-inline">Name </del>+ &#039; &#039; + isnull(<del class="diffchange diffchange-inline">b</del>.<del class="diffchange diffchange-inline">Email</del>, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;<del class="diffchange diffchange-inline">Services Requested</del>: &#039; <del class="diffchange diffchange-inline"> </del>+ &#039;&lt;br&gt;&#039; + <del class="diffchange diffchange-inline">isnull(</del>a.<del class="diffchange diffchange-inline">ServReq,</del>&#039;&#039;<del class="diffchange diffchange-inline">)  </del>+ &#039;&lt;br&gt;&#039; +&#039;<del class="diffchange diffchange-inline">change order status on arrival &amp; leaving job; </del>+ <del class="diffchange diffchange-inline">ADD A TIME TICKET WITH NOTE: </del>&#039; + &#039;&lt;br&gt;&#039; + isnull(a.<del class="diffchange diffchange-inline">ServPerf</del>,&#039;&#039;) <del class="diffchange diffchange-inline">  </del>+ &#039;&lt;br&gt;&lt;<del class="diffchange diffchange-inline">br</del>&gt;&#039; <del class="diffchange diffchange-inline"> </del>as Summary</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">                        else &#039;&#039; + &#039;&#039; end) end) + </ins>&#039; [&#039; +<ins class="diffchange diffchange-inline">isnull(</ins>cast(a.OrderNumber as varchar(<ins class="diffchange diffchange-inline">100</ins>)<ins class="diffchange diffchange-inline">), &#039;&#039;</ins>) + &#039;] <ins class="diffchange diffchange-inline">&#039;  </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">                        +&#039;</ins>: &#039;+ a.CustName <ins class="diffchange diffchange-inline">+ &#039; </ins> <ins class="diffchange diffchange-inline">- Status Updated By: &#039;+(Select Name From SMPUser Where UserName = a.WhoEdit) </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">                        </ins>as Subject, <ins class="diffchange diffchange-inline">+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">                        </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&lt;font size=&quot;2&quot; face=&quot;verdana&quot; color=&quot;black&quot;&gt;&#039; </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&#039; +</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt; &lt;strong&gt;&#039; +&#039;Customer: &#039;+  a.BillName + &#039;&lt;/strong&gt;&lt;br/&gt;&#039;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&#039; +</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&#039; +&#039;Site Address: &#039;+ &#039;&lt;br/&gt;&#039; +</ins>a.CustName  </div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; + a.<ins class="diffchange diffchange-inline">Address1+&#039;</ins>, &#039;</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; +&#039;&#039;+ a.<ins class="diffchange diffchange-inline">City </ins>+ &#039;<ins class="diffchange diffchange-inline">, </ins>&#039; + a.<ins class="diffchange diffchange-inline">St+</ins>&#039; &#039; +<ins class="diffchange diffchange-inline">a</ins>.<ins class="diffchange diffchange-inline">Zip</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;<ins class="diffchange diffchange-inline">&#039; +</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;</ins>&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; +&#039;<ins class="diffchange diffchange-inline">Site Phone </ins>: &#039; + <ins class="diffchange diffchange-inline">(Select distinct </ins>isnull(a.<ins class="diffchange diffchange-inline">fPhone</ins>, &#039;&#039;) <ins class="diffchange diffchange-inline">From CustCont b Where a.contactuid = b.uid) </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;<ins class="diffchange diffchange-inline">&#039; +&#039;Contact: &#039;+ (Select distinct b.Name From CustCont b Where b.UID = a.Contactuid) + </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;</ins>&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; +&#039;<ins class="diffchange diffchange-inline">Email </ins>: &#039; + <ins class="diffchange diffchange-inline">(Select distinct </ins>isnull(<ins class="diffchange diffchange-inline">b</ins>.<ins class="diffchange diffchange-inline">Email</ins>, &#039;&#039;) <ins class="diffchange diffchange-inline">From CustCont b Where a.contactuid = b.uid) </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;<ins class="diffchange diffchange-inline">&#039; +</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;</ins>&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; +&#039;<ins class="diffchange diffchange-inline">Service Order Number</ins>: <ins class="diffchange diffchange-inline"> &#039; +&#039;&lt;strong&gt;</ins>&#039;+ <ins class="diffchange diffchange-inline">          coalesce(convert</ins>(<ins class="diffchange diffchange-inline">varchar, </ins>a.<ins class="diffchange diffchange-inline">Ordernumber)</ins>, &#039;&#039;)<ins class="diffchange diffchange-inline">+&#039;&lt;/strong&gt;&#039;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;<ins class="diffchange diffchange-inline">&#039; </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;</ins>&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; + &#039;Order <ins class="diffchange diffchange-inline">Summary: &#039; + a.Summary+ &#039; &#039;+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&#039; + &#039;Taken By:  &#039; + a.TakenBy+ &#039; &#039;+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&#039; + &#039;Open Date/Time</ins>: &#039; +isnull(cast(a.<ins class="diffchange diffchange-inline">DateTimeIn </ins>as varchar(<ins class="diffchange diffchange-inline">100</ins>)),&#039;&#039;) <ins class="diffchange diffchange-inline">+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;<ins class="diffchange diffchange-inline">&lt;br/&gt;&#039; + &#039;Date/Time Due</ins>: <ins class="diffchange diffchange-inline"> </ins>&#039; +isnull<ins class="diffchange diffchange-inline">(cast</ins>(a.<ins class="diffchange diffchange-inline">DateTimeDue as varchar(100))</ins>,&#039;&#039;) +</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; + &#039;<ins class="diffchange diffchange-inline">Order Status</ins>: <ins class="diffchange diffchange-inline">  </ins>&#039; + <ins class="diffchange diffchange-inline">a</ins>.<ins class="diffchange diffchange-inline">OrderStatus+ &#039; &#039;+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;&lt;br/&gt;&#039; </ins>+ &#039;<ins class="diffchange diffchange-inline">Close Date/Time:</ins>&#039; +isnull(<ins class="diffchange diffchange-inline">cast(a</ins>.<ins class="diffchange diffchange-inline">DateTimeClosed as varchar(100))</ins>,&#039;&#039;) <ins class="diffchange diffchange-inline">+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;<ins class="diffchange diffchange-inline">&#039; + &#039;SLA Category: &#039; + a.SLACategory+ &#039; &#039;+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+ &#039;</ins>&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; + &#039;<ins class="diffchange diffchange-inline">Refrence Number</ins>: &#039; <ins class="diffchange diffchange-inline">+ a.RefNum+ &#039; &#039;+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; + <ins class="diffchange diffchange-inline">&#039;Tech Assigned:  &#039; + </ins>a.<ins class="diffchange diffchange-inline">AssignedTo+ </ins>&#039; &#039;<ins class="diffchange diffchange-inline">+</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/&gt;&lt;strong</ins>&gt;&#039;+&#039;<ins class="diffchange diffchange-inline">Services Requested:&#039; </ins>+ &#039;<ins class="diffchange diffchange-inline">&lt;strong&gt;&#039;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/</ins>&gt;&#039; +isnull(a.<ins class="diffchange diffchange-inline">ServReq</ins>,&#039;&#039;)  </div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>+ &#039;&lt;br<ins class="diffchange diffchange-inline">/&gt;&#039; </ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">+&#039;&lt;div align=&quot;center&quot;</ins>&gt; &lt;<ins class="diffchange diffchange-inline">span style=&quot;font-size:smaller;&quot;&gt;&lt;/span&gt;&lt;/div&gt;&lt;/font</ins>&gt;&#039;</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>as Summary</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td></tr> </table> DavidH https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=6142&oldid=prev DavidH: /* Modifying outbound looks and information Emails */ 2016-07-26T17:48:08Z <p><span dir="auto"><span class="autocomment">Modifying outbound looks and information Emails</span></span></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:48, 26 July 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l91" >Line 91:</td> <td colspan="2" class="diff-lineno">Line 91:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;<del class="diffchange diffchange-inline">Bemuda Elevator </del>Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;<ins class="diffchange diffchange-inline">Company Name </ins>Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td></tr> </table> DavidH https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=6016&oldid=prev DavidG at 23:38, 8 March 2016 2016-03-08T23:38:54Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 23:38, 8 March 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;SME Automatic Outbound Email Event&#039;&#039;&#039;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;SME Automatic Outbound Email Event&#039;&#039;&#039;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;The purpose of this add on program is to automatically <del class="diffchange diffchange-inline">notifiy </del>Techs and Customers of creation/closing</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;The purpose of this add on program is to automatically <ins class="diffchange diffchange-inline">notify </ins>Techs and Customers of creation/closing</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>and scheduling of Service Tickets or Issues within SME. This bundled with the SME ability to handle</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>and scheduling of Service Tickets or Issues within SME. This bundled with the SME ability to handle</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>incoming mail can create a powerful tool for capturing and issuing emails automatically without SME</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>incoming mail can create a powerful tool for capturing and issuing emails automatically without SME</div></td></tr> </table> DavidG https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=6015&oldid=prev DavidG at 23:38, 8 March 2016 2016-03-08T23:38:28Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 23:38, 8 March 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;SME Automatic Outbound Email Event&#039;&#039;&#039;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;SME Automatic Outbound Email Event&#039;&#039;&#039;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;The purpose of this add on program is to automatically <del class="diffchange diffchange-inline">notified </del>Techs and Customers of creation/closing</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;The purpose of this add on program is to automatically <ins class="diffchange diffchange-inline">notifiy </ins>Techs and Customers of creation/closing</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>and scheduling of Service Tickets or Issues within SME. This bundled with the SME ability to handle</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>and scheduling of Service Tickets or Issues within SME. This bundled with the SME ability to handle</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>incoming mail can create a powerful tool for capturing and issuing emails automatically without SME</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>incoming mail can create a powerful tool for capturing and issuing emails automatically without SME</div></td></tr> </table> DavidG https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=5909&oldid=prev CraigL: added exclusive access note 2015-08-04T15:29:06Z <p>added exclusive access note</p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:29, 4 August 2015</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l11" >Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* SME Field Scheduler for setup of Incoming and Outgoing Mail</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* SME Field Scheduler for setup of Incoming and Outgoing Mail</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Admin account in SME must have a valid and working SMTP outgoing email, see [[Email Settings]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Admin account in SME must have a valid and working SMTP outgoing email, see [[Email Settings]]</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* Exclusive Access is Required - All Users Must Be Out of SME</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;&#039;&#039;&#039;Not covered in this add on&#039;&#039;&#039;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;&#039;&#039;&#039;Not covered in this add on&#039;&#039;&#039;</div></td></tr> </table> CraigL https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=5584&oldid=prev Marks at 19:57, 20 November 2014 2014-11-20T19:57:49Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:57, 20 November 2014</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7" >Line 7:</td> <td colspan="2" class="diff-lineno">Line 7:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Requirements ==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Requirements ==</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">• </del>SME version 7.1 or later</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">* </ins>SME version 7.1 or later</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">&lt;br&gt;• </del>SME Web services setup on IIS for incoming mail. SME does not capture emails directly.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">* </ins>SME Web services setup on IIS for incoming mail. SME does not capture emails directly.</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">&lt;br&gt;• </del>SME Field Scheduler for setup of Incoming and Outgoing Mail</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">* </ins>SME Field Scheduler for setup of Incoming and Outgoing Mail</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">* Admin account in SME must have a valid and working SMTP outgoing email, see [[Email Settings]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;&#039;&#039;&#039;Not covered in this add on&#039;&#039;&#039;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;&#039;&#039;&#039;Not covered in this add on&#039;&#039;&#039;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">&lt;br&gt;• </del>Sending Tickets to customer automatically</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">* </ins>Sending Tickets to customer automatically</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">&lt;br&gt;• </del>Email campaigns</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">* </ins>Email campaigns</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> </table> Marks https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=4741&oldid=prev Marks at 19:15, 12 March 2014 2014-03-12T19:15:05Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:15, 12 March 2014</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l52" >Line 52:</td> <td colspan="2" class="diff-lineno">Line 52:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#039;<del class="diffchange diffchange-inline">&amp;</del>&lt;br&gt;&#039; = new line.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#039;&lt;br&gt;&#039; = new line.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l87" >Line 87:</td> <td colspan="2" class="diff-lineno">Line 87:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> </del>&lt;nowiki&gt;</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki&gt;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/nowiki&gt;</div></td></tr> </table> Marks https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=4740&oldid=prev Marks at 19:14, 12 March 2014 2014-03-12T19:14:09Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:14, 12 March 2014</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l51" >Line 51:</td> <td colspan="2" class="diff-lineno">Line 51:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Otherwise, you&#039;re just writing the email text and adding some simple HTML for formatting.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Otherwise, you&#039;re just writing the email text and adding some simple HTML for formatting.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#039;&lt;br&gt;&#039; = new line.</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&lt;nowiki&gt;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#039;<ins class="diffchange diffchange-inline">&amp;</ins>&lt;br&gt;&#039; = new line.</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&lt;/nowiki&gt;</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sample Template:</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Sample Template:</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;nowiki&gt;</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(max)) + &#039;] for : &#039; + a.CustName  as Subject,</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(max)) + &#039;] for : &#039; + a.CustName  as Subject,</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>isnull(a.CustName,&#039;&#039;) + &#039;&lt;br&gt;&#039; + isnull(a.addressblock, &#039;&#039;) + &#039;&lt;br&gt;&#039; + a.Summary&#039; + &#039;&lt;br&gt;&lt;br&gt;&#039; + cast(a.ordernumber as varchar(max)) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Services Performed:&#039; +  &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;) as Summary</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>isnull(a.CustName,&#039;&#039;) + &#039;&lt;br&gt;&#039; + isnull(a.addressblock, &#039;&#039;) + &#039;&lt;br&gt;&#039; + a.Summary&#039; + &#039;&lt;br&gt;&lt;br&gt;&#039; + cast(a.ordernumber as varchar(max)) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Services Performed:&#039; +  &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;) as Summary</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/nowiki&gt;</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>For a test order with these fields:</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>For a test order with these fields:</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l83" >Line 83:</td> <td colspan="2" class="diff-lineno">Line 87:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;nowiki<del class="diffchange diffchange-inline">/</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline"> </ins>&lt;nowiki<ins class="diffchange diffchange-inline">&gt;</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&gt;</div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&lt;/nowiki</ins>&gt;</div></td></tr> </table> Marks https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=4739&oldid=prev Marks at 19:04, 12 March 2014 2014-03-12T19:04:35Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:04, 12 March 2014</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l83" >Line 83:</td> <td colspan="2" class="diff-lineno">Line 83:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>/<del class="diffchange diffchange-inline">**</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&lt;nowiki</ins>/</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">**/</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&gt;</ins></div></td></tr> </table> Marks https://www.high5software.com//mediawiki/index.php?title=Automated_Email_Installation&diff=4685&oldid=prev Marks at 16:39, 12 March 2014 2014-03-12T16:39:25Z <p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:39, 12 March 2014</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l83" >Line 83:</td> <td colspan="2" class="diff-lineno">Line 83:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The standard outgoing email format looks like this:</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">/**</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;[&#039; + cast(a.OrderNumber as varchar(20)) + &#039;] for : &#039; + a.CustName  as Subject, a.CustName + &#039;&lt;br&gt;&#039; +isnull(a.AddressBlock, &#039;&#039;) + &#039;&lt;br&gt;&#039; +&#039;Bemuda Elevator Service Order &#039;  +  cast(a.DateTimeIn as varchar(100)) + &#039;    has been &#039; +isnull( a.OrderStatus,&#039;&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Priority Level:&#039;  +isnull(cast(a.Priority as varchar(20)),&#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Summary:&#039; +isnull(a.Summary, &#039;Summary&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;Contract type:&#039;  +isnull(a.SLACategory, &#039;FSMA or E&amp;L&#039;)+ &#039;&lt;br&gt;&lt;br&gt;&#039; + &#039;Order number : &#039;+isnull(cast(a.RefNum as varchar(20)),&#039;&#039;) +&#039;  Technician assigned: &#039; + isnull(a.AssignedTo, &#039;Nobody&#039;) + &#039;.&#039;  + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Site contact: &#039; + b.Name + &#039; &#039; + isnull(b.Email, &#039;&#039;) + &#039;&lt;br&gt;&lt;br&gt;&#039; +&#039;Services Requested: &#039;  + &#039;&lt;br&gt;&#039; + isnull(a.ServReq,&#039;&#039;)  + &#039;&lt;br&gt;&#039; +&#039;change order status on arrival &amp; leaving job; + ADD A TIME TICKET WITH NOTE: &#039; + &#039;&lt;br&gt;&#039; + isnull(a.ServPerf,&#039;&#039;)  + &#039;&lt;br&gt;&lt;br&gt;&#039;  as Summary</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">**/</ins></div></td></tr> </table> Marks