none
How to paste HTML email into string (Daniel Pineault?) RRS feed

  • Question

  • Hey guys, I have this template email I'm trying to use in a send e-mail function (written by Daniel Pineault) that takes HTML for the body. I viewed the templates source and I retrieve the HTML code from the email, but if I paste it into the code's string it creates a travesty of text and destroys the call to the function. Any ideas how to make this work? Here's the HTML:

    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
    /* Font Definitions */
    @font-face
    	{font-family:Helvetica;
    	panose-1:2 11 6 4 2 2 2 2 2 4;}
    @font-face
    	{font-family:"Cambria Math";
    	panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    	{font-family:Calibri;
    	panose-1:2 15 5 2 2 2 4 3 2 4;}
    @font-face
    	{font-family:Georgia;
    	panose-1:2 4 5 2 5 4 5 2 3 3;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    	{margin:0in;
    	margin-bottom:.0001pt;
    	font-size:11.0pt;
    	font-family:"Calibri",sans-serif;}
    a:link, span.MsoHyperlink
    	{
    	color:#0563C1;
    	text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    	{
    	color:#954F72;
    	text-decoration:underline;}
    p.msonormal0, li.msonormal0, div.msonormal0
    	{
    	
    	margin-right:0in;
    	
    	margin-left:0in;
    	font-size:11.0pt;
    	font-family:"Calibri",sans-serif;}
    span.EmailStyle18
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle19
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle20
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle21
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle22
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle23
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle24
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle25
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle26
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle27
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle28
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle29
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle30
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    span.EmailStyle31
    	{
    	font-family:"Calibri",sans-serif;
    	color:windowtext;}
    .MsoChpDefault
    	{
    	font-size:10.0pt;}
    @page WordSection1
    	{size:8.5in 11.0in;
    	margin:1.0in 1.0in 1.0in 1.0in;}
    div.WordSection1
    	{page:WordSection1;}
    --></style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div style='color:#1F497D'><o:p></o:p></span></p><p respond by <u>replying to all</u> and complete the grid below by <b><span style='color:red'>16:00 </span></b>whether your unit has any VAD patients. <o:p></o:p></p><p If you have a VAD patient in your unit, please fill out the grid below&nbsp; and put an “X” at the appropriate box, and/or comment when appropriate, i.e. evening shift will complete dressing change and document by 23:59.<o:p></o:p></p><p no VAD patients on unit, please reply with “No VAD patients”.<o:p></o:p></p><p border=0 cellspacing=0 cellpadding=0 width=1380 style='width:1035.0pt;border-collapse:collapse'><tr style='height:45.8pt'><td width=81 rowspan=2 valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Date<o:p></o:p></span></b></p></td><td width=64 rowspan=2 valign=top style='width:48.0pt;border:solid #F4B083 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Room#<o:p></o:p></span></b></p></td><td width=64 rowspan=2 valign=top style='width:48.0pt;border:solid #F4B083 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>FIN#<o:p></o:p></span></b></p></td><td width=97 rowspan=2 valign=top style='width:72.5pt;border:solid #F4B083 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Last Name<o:p></o:p></span></b></p></td><td width=93 colspan=2 valign=top style='width:70.05pt;border-top:solid #F4B083 1.0pt;border-left:none;border-bottom:solid #F4B083 1.5pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Daily Weight<o:p></o:p></span></b></p></td><td width=88 rowspan=2 valign=top style='width:65.8pt;border:solid #F4B083 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Dressing Change Frequency per Order<o:p></o:p></span></b></p></td><td width=173 colspan=3 valign=top style='width:129.65pt;border-top:solid #F4B083 1.0pt;border-left:none;border-bottom:solid #F4B083 1.5pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Dressing Change<o:p></o:p></span></b></p></td><td width=162 colspan=3 valign=top style='width:121.5pt;border-top:solid #F4B083 1.0pt;border-left:none;border-bottom:solid #F4B083 1.5pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Date</span></b><b><span style='font-size:12.0pt'>,<span style='color:black'> Time</span> &amp; <span style='color:red'>Initials </span><span style='color:black'>of Driveline change on Photograph<o:p></o:p></span></span></b></p></td><td width=84 rowspan=2 valign=top style='width:63.0pt;border:solid #F4B083 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:red'>Only one active Speed Order in Cerner </span></b><b><span style='font-size:12.0pt;color:black'>– </span><span style='color:black'>(Should not be a Physician to Clinician Order)</span></b><b><span style='font-size:12.0pt;color:red'><o:p></o:p></span></b></p></td><td width=114 rowspan=2 valign=top style='width:85.5pt;border:solid #F4B083 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>VAD Speed Assessed and Documented by Nurse – </span><span style='color:red'>(Speed documentation must match the one active VAD Speed order)</span></b><b><span style='font-size:12.0pt;color:black'><o:p></o:p></span></b></p></td><td width=147 colspan=2 valign=top style='width:110.05pt;border-top:solid #F4B083 1.0pt;border-left:none;border-bottom:solid #F4B083 1.5pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Vital Signs Assessment as per Unit Protocol<o:p></o:p></span></b></p></td><td width=213 valign=top style='width:159.95pt;border-top:solid #F4B083 1.0pt;border-left:none;border-bottom:solid #F4B083 1.5pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:45.8pt'><p style='font-size:12.0pt;color:black'>Comments<o:p></o:p></span></b></p></td></tr><tr style='height:61.5pt'><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>Yes<o:p></o:p></span></b></p></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>No<o:p></o:p></span></b></p></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>Yes<o:p></o:p></span></b></p></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>Not Due<o:p></o:p></span></b></p></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>N/A<o:p></o:p></span></b></p></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>Yes<o:p></o:p></span></b></p></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>Not Due<o:p></o:p></span></b></p></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>N/A<o:p></o:p></span></b></p></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>Yes<o:p></o:p></span></b></p></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'><p style='font-size:12.0pt;color:black'>No<o:p></o:p></span></b></p></td><td width=213 valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:61.5pt'></td></tr><tr style='height:16.5pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>4/1/2019<o:p></o:p></span></i></b></p></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>1234<o:p></o:p></span></i></b></p></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>123456<o:p></o:p></span></i></b></p></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>ABCD<o:p></o:p></span></i></b></p></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>X<o:p></o:p></span></i></b></p></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>q48hrs<o:p></o:p></span></i></b></p></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>X<o:p></o:p></span></i></b></p></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>X<o:p></o:p></span></i></b></p></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>Y<o:p></o:p></span></i></b></p></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>Y<o:p></o:p></span></i></b></p></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>X<o:p></o:p></span></i></b></p></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'><p style='font-size:12.0pt;color:#1F497D'>Next dressing change 4/2/19<o:p></o:p></span></i></b></p></td></tr><tr style='height:16.5pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td></tr><tr style='height:16.5pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td></tr><tr style='height:16.5pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td></tr><tr style='height:16.5pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:16.5pt'></td></tr><tr style='height:15.75pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;background:#FBE4D5;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td></tr><tr style='height:15.75pt'><td width=81 nowrap valign=top style='width:61.0pt;border:solid #F4B083 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=64 nowrap valign=top style='width:48.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=97 nowrap valign=top style='width:72.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=42 nowrap valign=top style='width:31.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=51 nowrap valign=top style='width:38.55pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=88 nowrap valign=top style='width:65.8pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=59 nowrap valign=top style='width:44.15pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=66 nowrap valign=top style='width:49.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=48 nowrap valign=top style='width:.5in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=54 nowrap valign=top style='width:40.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=60 nowrap valign=top style='width:45.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=84 nowrap valign=top style='width:63.0pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=114 nowrap valign=top style='width:85.5pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=72 nowrap valign=top style='width:.75in;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=75 nowrap valign=top style='width:56.05pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td><td width=213 nowrap valign=top style='width:159.95pt;border-top:none;border-left:none;border-bottom:solid #F4B083 1.0pt;border-right:solid #F4B083 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.75pt'></td></tr></table><p In order to maintain The Joint Commission compliance for Ventricular Assisted Device patients, it is expected that daily weights (DSDF3.2 &amp; DSCF 3.2) and dressing changes (DSDF3.2 &amp; DSCF3.2)&nbsp; as ordered within Cerner is completed and documented daily. <o:p></o:p></p><p style='margin-bottom:12.0pt;line-height:150%;background:white'><b><span style='font-family:"Arial",sans-serif;color:#075080'>J. Alexander Batista, BSN, RN, CRNI</span></b><span style='font-family:"Helvetica",sans-serif;color:#075080'><br></span><span style='font-size:10.0pt;line-height:150%;font-family:"Arial",sans-serif;color:#73808A'>COMPANY NAME<br>Clinical Data Analyst - Orlando <br>M 786-314-1351</span><o:p></o:p></p><p style='font-size:9.0pt;font-family:"Georgia",serif'>“<b>Quality is not an act, it is a habit”&nbsp; Aristotle</b> </span></i><o:p></o:p></p><p style='font-size:9.0pt;font-family:"Georgia",serif'>&nbsp;</span></i><o:p></o:p></p><p style='font-size:9.0pt;color:red'>CONFIDENTIAL. PATIENT SAFETY WORK PRODUCT. Protected under the Patient Safety and Quality </span></b><o:p></o:p></p><p style='font-size:9.0pt;color:red'>Improvement Act. Do NOT disclose unless authorized by the PSOrg Advisory Committee</span></b><b><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:red'>.</span></b><o:p></o:p></p></div></body></html>


    • Edited by InnVis Friday, September 6, 2019 2:09 PM Some of the code was cut
    Friday, September 6, 2019 1:57 PM

All replies

  • Maybe it's time for a new subforum for Daniel.....
    Friday, September 6, 2019 2:03 PM
  • LOL, hey he writes and shares a LOT of great codes. Then when I ask a specific question regarding the code, some of the community reply by "ask the source." Or simply blank out, check my posts regarding the e-mail function - took almost a week to answer and then Daniel answers it in a few minutes.
    Friday, September 6, 2019 2:05 PM
  • Daniel does a great job but doesn't mean that we all we use his code all the time and we have "exploited" to it's full extent...so I am suggesting that if you have a lot of questions about his code it would be better to open a direct private channel to him and resolve issues promptly..

    I am pretty sure that Daniel if encounters anything unusual will do it's best to inform everyone.

    As the code itself while it's great ( I assume I have never used it)... It's not the only email solution...for many years personally I have used the CDO option to perform everything..from Mass emailing to attachments and HTML with headers...tables graphics...you name it....and all these with a tiny .dll without Outlook.. without any extra 3rd party...

    Also recently it came to my attention that is another option called vbSend (never used it...)..that is supposed to be more Exchange friendly(although with some extra work CDO was working fine on my Exchange...but these are stories from the past)

    Friday, September 6, 2019 2:20 PM
  • Thanks for your input John. If you have the answer to my question, you're more then welcome to help me solve it. I just want to know how to paste HTML into VBA code without destroying the integrity. Thank you also for bringing up other solutions for emailing, unfortunately agile tool development has to adapt when working for large companies that are just beginning to adopt it in order to supplement their every day operations. My goal is to merge my tools with existing business practices, not change their entire operation to use my tool. I have come across very specific challenges and the community has been excellent in helping me solve most of them with little compromise to workflows. If you have further suggestions unrelated to the resolution of this post, please feel free to open a direct private channel to me.
    Friday, September 6, 2019 2:29 PM
  • As I said I haven't used Daniel's code...the only thing to add that might help you is that HTML on Outlook is not that "good"...it's quite restrictive...so the easiest way would be to compose an HTML email to Outlook  the way you want it and switch to source view to examine it....and probably answer your question.

    For what it worths HTML is nothing more than a string to VBA...it just has the formatting that makes it display the way it does.

    Friday, September 6, 2019 2:36 PM
  • If I remove all of the lines and make the html into one long line, do you think it will work or will it just paste the entire html code into the email body?
    Friday, September 6, 2019 2:48 PM
  • How are you retrieving the template HTML?  I typically use http://www.devhut.net/2012/05/14/vba-read-file-into-memory/ and assign the returned value to a variable that I can then use/customize...  I quickly tested with you sample HTML and I generated an e-mail.

    As John also noted, Outlook is HORRIBLE with html and more often than not you need to do a lot of massaging to get the desired result.  You are best to keep things simple and only use basic tags.


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Friday, September 6, 2019 2:54 PM
  • JonSmith also had a unique approach to using templates for e-mailing, you may wish to take a look at https://www.utteraccess.com/forum/index.php?showtopic=2046398&view=findpost&p=2665171

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Friday, September 6, 2019 3:06 PM
  • I see, I can keep using templates much easier. Just wanted to make use of the full function. I actually modified your original email function to take templates and I stored them in a share folder:

    Function SendHTMLEmail(ByVal sTo As String, _
                           ByVal sSubject As String, _
                           ByVal sBody As String, _
                           ByVal bEdit As Boolean, _
                           Optional sBCC As Variant, _
                           Optional aAttachments As Variant, _
                           Optional strSourceEMail As String, _
                           Optional sAccount As Variant)
    
    If strSourceEMail = "" Then
        Set oOutlookMsg = oOutlook.CreateItem(olMailItem)
        Else
        Set oOutlookMsg = oOutlook.Session.OpenSharedItem(strSourceEMail)
        End If



    • Edited by InnVis Friday, September 6, 2019 3:12 PM
    Friday, September 6, 2019 3:08 PM
  • As John also noted, Outlook is HORRIBLE with html and more often than not you need to do a lot of massaging to get the desired result.  You are best to keep things simple and only use basic tags.


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Great selection of word..:)... HORRIBLE...I spend quite sometime to get fixed to way they wanted( an email with tables ..cell colored..so it can easily viewed on mobile)...and the funny part was the inspiration came from the mother company that has such kind of emails...but they have a 3rd party solution to make the massaging..but when you have someone to do it for free.....:). 

    Something else... personally I find the use of Outlook for such simple tasks as Mass emailing a complete waste of resources ( Daniel I am not blaming your code in any way..it should be great)... Outlook is not the simple stupid email client ...but a complete Enterprise communication/collaboration solution that is quite heavy when it comes to automate it... because there was mention about Enterprise I would recommend looking to other means to perform these tasks

    (Hint : the solution of Outlook works great ..but what if your application gets to production level with older computers ...with NO office and just an Access Runtime to do the dirty job... something for consideration.)

    Friday, September 6, 2019 3:12 PM
  • This is very good information for future implementation at other facilities. Fortunately, the current facility I'm in has all up-to-date hardware/software.
    Friday, September 6, 2019 3:15 PM
  • I can keep using templates much easier.

    Hi InnVis,

    Not all users of my (100+) completely different applications want/can use Outlook. That is why I concentrated on CDO, and a way to generate HTML code.

    I saw the template: quite impressive, but very hard to understand and manipulate with - I guess - 95% of "not necessary" overhead?

    I do not use templates in the way you showed, but developped some "standard building blocks" that do the work. The building blocks contain the necessary HTML tags.

    The making of a new flexible HTMLbody becomes then quite easy:
        - Make_title …
        - Write_text …
        - Make_table …
            - Write_rows(s) …
        - End_table
        - Write_text …
        etc.

    Any "text" can even contain "Tokens", that can be evaluated to complete new HTML string with all the necessary elements: paragraphs, tables, …

    It is just a matter of simple(? - yes, if structured) string manipulatiuons.

    Imb.

    Tuesday, September 10, 2019 9:40 AM
  • If my memory serves me right ...the template has too much CSS and Outlook is not very agile on too "much"..

    Reduce it to absolutely least HTML ...test and add step by step.

    Tuesday, September 10, 2019 12:13 PM
  • Hey Daniel, I've been trying to dig my head into this email template demo... When I open the email on template mode and try to send it, it's supposed to give me a message, but instead it's returning an error. Thoughts?

    • Edited by InnVis Monday, September 16, 2019 12:25 PM
    Monday, September 16, 2019 12:24 PM
  • Could you be facing http://www.devhut.net/2014/10/31/createobjectoutlook-application-does-not-work-now-what/?


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, September 16, 2019 1:05 PM
  • Found a workaround to the original template issue, BUT I'm now actually having a bigger issue and I think I know what the problem is but don't quite have a solution for it... For example, if my outlook application is open, my call for 5 emails works beautifully:

    Call SendHTMLEmail("dep1@xyz.com", "1W -  VAD Daily Audit - Please respond by 16:00", "", False, , , "P:\Orlando\Nurse Analyst\DO_NOT_OPEN_BACKEND\OUTLOOK DISTRIBUTION TEMPLATES\AUTO VAD\VAD.msg")
    Call SendHTMLEmail("dep2@xyz.com", "O2CV -  VAD Daily Audit - Please respond by 16:00", "", False, , , "P:\Orlando\Nurse Analyst\DO_NOT_OPEN_BACKEND\OUTLOOK DISTRIBUTION TEMPLATES\AUTO VAD\VAD.msg")
    Call SendHTMLEmail("dep3@xyz.com", "CV3 -  VAD Daily Audit - Please respond by 16:00", "", False, , , "P:\Orlando\Nurse Analyst\DO_NOT_OPEN_BACKEND\OUTLOOK DISTRIBUTION TEMPLATES\AUTO VAD\VAD.msg")
    Call SendHTMLEmail("dep4@xyz.com", "GT5 -  VAD Daily Audit - Please respond by 16:00", "", False, , , "P:\Orlando\Nurse Analyst\DO_NOT_OPEN_BACKEND\OUTLOOK DISTRIBUTION TEMPLATES\AUTO VAD\VAD.msg")
    Call SendHTMLEmail("dep5@xyz.com", "GT7 -  VAD Daily Audit - Please respond by 16:00", "", False, , , "P:\Orlando\Nurse Analyst\DO_NOT_OPEN_BACKEND\OUTLOOK DISTRIBUTION TEMPLATES\AUTO VAD\VAD.msg")

    BUT if my outlook is not running, the code opens up an outlook instance in the background to send an email, but the code runs faster then the application can open and close a new instance to send an email so it returns this error:

    Monday, September 16, 2019 2:43 PM
  • BUT if my outlook is not running, the code opens up an outlook instance in the background to send an email, but the code runs faster then the application can open and close a new instance to send an email so it returns this error

    Hi InnVis,

    Try DoEvents after opening Outlook, if necessary a couple of times.

    Imb.

    Monday, September 16, 2019 3:29 PM
  • Never used a DoEvent before. Gave it a quick search and I keep getting results of people saying it's "Evil" lol. Mind giving me an example on how it can be used to get started?
    • Edited by InnVis Monday, September 16, 2019 4:15 PM
    Monday, September 16, 2019 4:15 PM
  • Never used a DoEvent before. Gave it a quick search and I keep getting results of people saying it's "Evil" lol.

    Hi InnVis,

    I am not afraid to use DoEvents when there are timing problems with some "external" actions.

    One example of use is after a CopyFile of a referenced library database with a development name to an application-specific name.

    The "Evil" part is, that DoEvents is not always (or always not?) necessary. If the program is running allright, you can test what the result is when you remove the DoEvents.

    Imb.

    Monday, September 16, 2019 6:03 PM
  • I love it, it worked!! Here's what I used:

    Debug.Print "CPUTask2 Start Now() = " & Now()
     
        For t = 1 To 100000000
        'We create a loop that will take 5-10 seconds to
        'complete
            zzz = zzz + (t / 2)
            If (t Mod 10000000) = 0 Then
                DoEvents
                'DoEvents pauses the loop so the operating
                'system can perform queued functions
                
                Debug.Print t
            End If
        Next
        Debug.Print "CPUTask End Now() = " & Now()

    I put one in between calls, I'll teak it to make it faster.

    Tuesday, September 17, 2019 1:09 PM