Solved

VBA-created Outlook email being cut off mid subject

Posted on 2013-01-23
11
911 Views
Last Modified: 2013-02-04
I have a VBA program that creates an Outlook email in html format. The email contains some html tables. Sometimes the email is cut off in the middle of a table.

I've checked for stray single quotes in the data and there are none. Is there a length limit to Outlook emails created with VBA?

Is there anything else that could be causing the email to be cut short?

Here's the code that creates the email.

            With oLookEmail  
               .To = "gzzzz@someco.com"
               .BodyFormat = olFormatHTML
               .HTMLBody = "<html><body style=""font-family:cambria; font-size:.9em;"">" & emailBody & emailBody2 & " </body></html>"
               .Subject = strEmailSubject
               .Display
            End With
0
Comment
Question by:Perfishent
  • 6
  • 5
11 Comments
 
LVL 84
ID: 38811254
I'm not aware of any limits on email messages. More likely your code is not properly forming the tables in the HTML source - can you show how you build emailBody and emailbody2?
0
 

Author Comment

by:Perfishent
ID: 38811382
I used debug.print to print out the email body. I then pasted it into a text file and opened it in a web browser. The html code is good and displays correctly in a browser.

Outlook makes a lot of formatting and other changes to the html code and cuts off the subject in the middle of one of the tables.

Here's what the code looks like before it's put into the Outlook email:

<html>
<body style="font-family:cambria; font-size:.9em;">
<b>Verification Due Date:</b> 1/23/2013
<br /><b>Verification Due By:</b> UPS (3:00)
<br /><b>Second Check:</b> No
<br /><b>Frequency:</b> B<br /><br /><table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em; border-width:3px; border-color:blue;">
<tr style="font-weight:bold">
<td colspan=2>Name Removed (4)</b></td><td style="width:150px;">Notes</td>
</tr><tr>
<td>Disposable:</td>
<td>0</td><td>&nbsp;</td>
</tr>
<tr>
<td>CHILD CUR :</td>
<td>382.62 </td><td>&nbsp;</td>
</tr>
<tr>
<td>STATE FEE:</td>
<td>2 </td><td>&nbsp;</td>
</tr>
</table>
<table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em;">
<tr>
<td colspan="2">CHILD CUR</td>
<td>Amount</td>
<td>Rate</td>
<td>Basis</td>
<td>Vendor</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Start Date</td>
<td>10/30/2012</td>
<td>382.62</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>NV CHLDSPT</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Stop Date</td>
<td> -</td>
<td>&nbsp;</td>
<td>50</td>
<td>D</td>
<td>Balance</td>
<td>0</td>
</tr>
</table>
<table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em;">
<tr>
<td colspan="2">144 STATE FEE&nbsp;</td>
<td>Amount</td>
<td>Rate</td>
<td>Basis</td>
<td>Vendor!!</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Start Date</td>
<td>10/30/2012&nbsp;</td>
<td>2&nbsp;</td>
<td>&nbsp;</td>
<td> &nbsp;</td>
<td>NV TREASUR&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Stop Date</td>
<td> -&nbsp;</td>
<td>&nbsp;</td>
<td>0&nbsp;</td>
<td>&nbsp;</td>
<td>Balance</td>
<td>0&nbsp;</td>
</tr>
</table>
<br /><table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em; border-width:3px; border-color:blue;">
<tr style="font-weight:bold">
<td colspan=2>Name Removed (12)</b></td><td style="width:150px;">Notes</td>
</tr><tr>
<td>Disposable:</td>
<td>0</td><td>&nbsp;</td>
</tr>
<tr>
<td>CHILD ARR :</td>
<td>207.69 </td><td>&nbsp;</td>
</tr>
<tr>
<td>STATE FEE:</td>
<td>2 </td><td>&nbsp;</td>
</tr>
</table>
<table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em;">
<tr>
<td colspan="2">CHILD ARR</td>
<td>Amount</td>
<td>Rate</td>
<td>Basis</td>
<td>Vendor</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Start Date</td>
<td>11/20/2012</td>
<td>207.69</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>NV CHLDSPT</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Stop Date</td>
<td> -</td>
<td>&nbsp;</td>
<td>50</td>
<td>D</td>
<td>Balance</td>
<td>0</td>
</tr>
</table>
<table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em;">
<tr>
<td colspan="2">144 STATE FEE&nbsp;</td>
<td>Amount</td>
<td>Rate</td>
<td>Basis</td>
<td>Vendor!!</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Start Date</td>
<td>11/20/2012&nbsp;</td>
<td>2&nbsp;</td>
<td>&nbsp;</td>
<td> &nbsp;</td>
<td>NV TREASUR&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Stop Date</td>
<td> -&nbsp;</td>
<td>&nbsp;</td>
<td>0&nbsp;</td>
<td>&nbsp;</td>
<td>Balance</td>
<td>0&nbsp;</td>
</tr>
</table>
<br /><table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em; border-width:3px; border-color:blue;">
<tr style="font-weight:bold">
<td colspan=2>Name Removed (51)</b></td><td style="width:150px;">Notes</td>
</tr><tr>
<td>Disposable:</td>
<td>0</td><td>&nbsp;</td>
</tr>
<tr>
<td>CHILD CUR :</td>
<td>91.38 </td><td>&nbsp;</td>
</tr>
<tr>
<td>STATE FEE:</td>
<td>2 </td><td>&nbsp;</td>
</tr>
</table>

<table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em;">
<tr>
<td colspan="2">CHILD CUR</td>
<td>Amount</td>
<td>Rate</td>
<td>Basis</td>
<td>Vendor</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Start Date</td>
<td>10/30/2012</td>
<td>91.38</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>NV CHLDSPT</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Stop Date</td>
<td> -</td>
<td>&nbsp;</td>
<td>50</td>
<td>D</td>
<td>Balance</td>
<td>0</td>
</tr>
</table>
<table border="1" cellpadding="3" cellspacing="0" style="font-family:cambria; font-size:.9em;">
<tr>
<td colspan="2">144 STATE FEE&nbsp;</td>
<td>Amount</td>
<td>Rate</td>
<td>Basis</td>
<td>Vendor!!</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Start Date</td>
<td>10/30/2012&nbsp;</td>
<td>2&nbsp;</td>
<td>&nbsp;</td>
<td> &nbsp;</td>
<td>NV TREASUR&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Stop Date</td>
<td> -&nbsp;</td>
<td>&nbsp;</td>
<td>0&nbsp;</td>
<td>&nbsp;</td>
<td>Balance</td>
<td>0&nbsp;</td>
</tr>
</table>

</body>
</html>
0
 
LVL 84
ID: 38811717
What about AFTER you drop it in to the Outlook email? Can you post the body HTML after Outlook does it's thing?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:Perfishent
ID: 38812035
<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 http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
      {font-family:Cambria;
      panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
      {margin:0in;
      margin-bottom:.0001pt;
      font-size:12.0pt;
      font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
      {mso-style-priority:99;
      color:blue;
      text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
      {mso-style-priority:99;
      color:purple;
      text-decoration:underline;}
span.EmailStyle17
      {mso-style-type:personal-compose;
      font-family:"Cambria","serif";
      font-weight:bold;}
.MsoChpDefault
      {mso-style-type:export-only;
      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=blue vlink=purple><div class=WordSection1><p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Verification Due Date:</span></b><span style='font-size:11.0pt;font-family:"Cambria","serif"'> 1/23/2013 <br><b>Verification Due By:</b> UPS (3:00) <br><b>Second Check:</b> No <br><b>Frequency:</b> B<o:p></o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='border:outset blue 2.25pt'><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Name Removed (4)<o:p></o:p></span></b></p></td><td width=150 style='width:112.5pt;padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Notes<o:p></o:p></span></b></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Disposable:<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>0<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CHILD CUR :<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>382.62 <o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>STATE FEE:<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>2 <o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif";display:none'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CHILD CUR<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Amount<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Rate<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Basis<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Vendor<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Start Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>10/30/2012<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>382.62<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>NV CHLDSPT<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Stop Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>-<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>50<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>D<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Balance<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>0<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif";display:none'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>144 STATE FEE&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Amount<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Rate<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Basis<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Vendor##<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Start Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>10/30/2012&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>2&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'></td><td style='border:none;padding:2.25pt 2.25pt 2.25pt 2.25pt'></td><td style='border:none;padding:2.25pt 2.25pt 2.25pt 2.25pt'></td></tr><tr height=0><td width=70 style='border:none'></td><td width=89 style='border:none'></td><td width=59 style='border:none'></td><td width=36 style='border:none'></td><td width=40 style='border:none'></td><td width=72 style='border:none'></td><td width=11 style='border:none'></td></tr></table><p class=MsoNormal><o:p>&nbsp;</o:p></p></div></body></html>
0
 
LVL 84
ID: 38812076
Try removing the .BodyType line ...
0
 

Author Comment

by:Perfishent
ID: 38827465
Do you mean remove the .bodyFormat line? I'll try that.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38827939
Sorry ... yes, try removing this line:

.BodyFormat = olFormatHTML
0
 

Author Comment

by:Perfishent
ID: 38829410
That doesn't change the way that Outlook rewrites the HTML code. Outlook still adds tons of formatting code:

<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 http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
      {font-family:Cambria;
      panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
      {margin:0in;
      margin-bottom:.0001pt;
      font-size:12.0pt;
      font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
      {mso-style-priority:99;
      color:blue;
      text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
      {mso-style-priority:99;
      color:purple;
      text-decoration:underline;}
span.EmailStyle17
      {mso-style-type:personal-compose;
      font-family:"Cambria","serif";
      font-weight:bold;}
.MsoChpDefault
      {mso-style-type:export-only;
      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=blue vlink=purple><div class=WordSection1><p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Verification Due Date:</span></b><span style='font-size:11.0pt;font-family:"Cambria","serif"'> 1/28/2013 <br><b>Verification Due By:</b> Courier South (11:00) <br><b>Second Check:</b> No <br><b>Frequency:</b> W<o:p></o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='border:outset blue 2.25pt'><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Grange, Mark (187)<o:p></o:p></span></b></p></td><td width=150 style='width:112.5pt;padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Notes<o:p></o:p></span></b></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Disposable:<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>667.97<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>FED STUL :<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>100.2 <o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif";display:none'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>FED STUL<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Amount<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Rate<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Basis<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Vendor<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Start Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>5/17/2010<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>217.5<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>B&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>US_DEPT_ED<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Stop Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>-<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>15<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>D<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Balance<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>796.17<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='border:outset blue 2.25pt'><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Toledo, Ramon (430)<o:p></o:p></span></b></p></td><td width=150 style='width:112.5pt;padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Notes<o:p></o:p></span></b></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Disposable:<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>1149.57<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CHILD CUR :<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>66.92 <o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CHILD CUR:<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>104.76 <o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CHILD CUR:<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>85.5 <o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif";display:none'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CHILD CUR<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Amount<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Rate<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Basis<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Vendor<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Start Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>8/15/2011<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>66.92<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CALIFORNIA<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Stop Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>-<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>13.01<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>D<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Balance<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>0<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif";display:none'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>110 CHILD CUR&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Amount<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Rate<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Basis<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Vendor##<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Start Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>8/15/2011&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>66.92&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CALIFORNIA&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Stop Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>-&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>13.01&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>D&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Balance<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>0&nbsp;<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif";display:none'><o:p>&nbsp;</o:p></span></p><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0><tr><td colspan=2 style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>110 CHILD CUR&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Amount<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Rate<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Basis<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Vendor##<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Start Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>8/15/2011&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>66.92&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>CALIFORNIA&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td></tr><tr><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Stop Date<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>-&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>13.01&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>D&nbsp;<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>Balance<o:p></o:p></span></p></td><td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Cambria","serif"'>0&nbsp;<o:p></o:p></span></p></td></tr></table><p class=MsoNormal><o:p>&nbsp;</o:p></p></div></body></html>
0
 
LVL 84
ID: 38829445
Outlook will add it's  own formatting tags and such - I don't think you can change that.

Does the example above display correctly, or does it cut off somewhere?
0
 

Author Comment

by:Perfishent
ID: 38845226
I've tested it for a while now and it does not cut off anymore. I think this fixed the issue. It would be nice to know why this fixed the issue. Can you explain why?
0
 
LVL 84
ID: 38845599
I think this fixed the issue
If you mean removing the "BodyFormat = olFormatHTML " line, then I'd simply assume that it was a matter of conflicting properties and such.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question