word format Macro help

N

newexler

New Member
Joined
Apr 3, 2009
Messages
18
Hi Experts,

I seek help in a macro which formats the table below to format to the as shown at the end of the

<!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} table.MsoTableGrid {mso-style-name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-border-insideh:.5pt solid windowtext; mso-border-insidev:.5pt solid windowtext; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1032"/> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--> Example.. . The input


<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:191;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> ID
</td> <td style="width:105.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> 34344
</td> <td style="width:114.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153"> Name
</td> <td style="width:114.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152"> exler
</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> Department
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> Pharmacy
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153"> Section
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152"> Delivery
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> Due Date
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> 23/4/2011
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:5;mso-yfti-lastrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> </tbody></table>
<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:191;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> Description
</td> <td style="width:105.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> Delivery of medicines
</td> <td style="width:114.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:1;mso-yfti-lastrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> </tbody></table>
-- A picture object here ---



<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:191;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> ID
</td> <td style="width:105.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> 34343
</td> <td style="width:114.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153"> Name
</td> <td style="width:114.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152"> Tom
</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> Department
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> Pharmacy
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153"> Section
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152"> Packing
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> Due Date
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> 23/4/2012
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:5;mso-yfti-lastrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;background:#F3F3F3;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> </tbody></table>
<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:191;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="145"> Description
</td> <td style="width:105.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141"> Packing of Medicines
</td> <td style="width:114.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> <tr style="mso-yfti-irow:1;mso-yfti-lastrow:yes"> <td style="width:109.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="145">
</td> <td style="width:105.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="141">
</td> <td style="width:114.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="153">
</td> <td style="width:114.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="152">
</td> </tr> </tbody></table>
--- A picture here ---

etc a lot of such tables in the word to be converted as below..



1. Each of the table has to be started with a header 3 number

2. Only single table per heading and all multiple tables has to be merged into one.
3. Empty cells rows have to be delete
4. Only two columns and rest of the columns should be split into next rows.
5. the picture has to be deleted.



The output from the macro:


1.1.1

<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:191;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:221.4pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> ID
</td> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> 34344
</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Department
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Pharmacy
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Due Date
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> 23/4/2011
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Description
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Delivery of medicines
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Name
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> exler
</td> </tr> <tr style="mso-yfti-irow:5;mso-yfti-lastrow:yes"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Section
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Delivery
</td> </tr> </tbody></table>

1.1.2



<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:191;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:221.4pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> ID
</td> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> 34343
</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Department
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Pharmacy
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Due Date
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> 23/4/2012
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Description
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Packing of Medicines
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Name
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Tom
</td> </tr> <tr style="mso-yfti-irow:5;mso-yfti-lastrow:yes"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Section
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt" valign="top" width="295"> Packing
</td> </tr> </tbody></table>
Please can some one help me, i know nothing of macros.

Thanks a lot in Advance.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
Hello, and welcome to the forum!

I think the reason you haven't received any replies is that the question is a little confusing. The title implies that you want to manipulate tables in Word. If that's the case, you might be better of with a Word macro. If your data is in Excel now, are you looking to create a Word document from it?
I'll try to help with it tomorrow...it's quite late here.
 
Upvote 0
Hi Cindy Ellis

Apologies, Yes it is word macro but have come to seek help here as vb macro i presume are same be it word or excel. I copied the whole content in excel and i confirm to you, it looks pretty much same. So i presume If macro to help me works in excel, i will use excel and copy back to word.

I have lots of such table and doing manually is killing me and probably have to keep repeating it.

Note: " ID: " is only delimiter or reference point to consider it as a new table with heading 3, rest all tables until a new "ID:" field is encountered should be merged with same formatting ( sizes of cells and color). To ensure only two columns exists in a table, one is field and other is content of it. This is only recoginisable format to the input software.

Thanks a lot for the help.
Cheers
 
Upvote 0
The data may look similar in Excel and Word, but the macro languages are different because the objects are different. I have had some luck working with tables in Word macros, though, so I'll see what I can do. I'll post back with questions as they come up.
Cindy
 
Last edited:
Upvote 0
Before I go too much further...are all of the tables organized EXACTLY the same as the 2 you posted, with the same number of blank rows betwen data, and the table split into two, just above the "Description" label? Or does the macro need to search for the label, then get the data from the cell below it, wherever it happens to be in the table.
Cindy
 
Upvote 0
OK...here is an inelegant but functional solution. Note that this is a Word macro, NOT Excel. (Forum moderators may need to move this to the non-Excel part of the forum.)

It has the following parts:
  • A main macro, FixDocument, that calls the rest of them.
  • 4 routines that do specific parts of the process
    • Add and Format the heading 3 style
    • Delete all of the pictures
    • Fix all the tables
    • Format the paragraph before each table as Heading 3.
If you don't like how one part works, just comment it out or edit it.

The code makes the following assumptions:
  • You really want to delete ALL of the pictures in the document
  • There are 4 columns in each of the tables to start with. If this isnt' true, the FixTables macro will not work.
  • All of the information that's in columns 3 and 4 should get appended to the bottom of the merged table
Sloppy things: Not all variables are declared
Inelegant things: It depends a lot on Select. That's very inefficient in Excel, but I really couldn't figure out how to do what needed to be done in Word without the Select statements.

So, with all those disclaimers...give it a try and let me know how it turns out.

Cindy
Code: 
Sub FixDocument()
    Application.ScreenUpdating = False  'comment this out for debugging
    Call AddHeadingStyles
    Call DeleteAllPics
    Call FixTables
    Call MakeHeaders
    Application.ScreenUpdating = True
End Sub
Sub DeleteAllPics()
'
' DelAllPics Macro deletes anything in the active document that is a graphic
'
'
    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = "^g"
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
End Sub
Sub FixTables()
'
'MergeTables Macro goes through the entire document, and gets rid of blank lines
'between tables, except where a new table starts with the identifier "ID"
'Do this before pulling data from existing tables to create new ones.  Or maybe
'just move columns 3 and 4 to columns 1 and 2?
    Dim tblDoc As Table
    If ActiveDocument.Tables.Count >= 1 Then
        For Each tblDoc In ActiveDocument.Tables
            tblDoc.Range.Rows.Height = 14
            tblDoc.Range.Columns.Width = 220 'this just makes them all the same to simplify the merge
            Set rngTable = tblDoc.Cell(1, 1).Range
            rngTable.Select
            rngTable.MoveEnd Unit:=wdCharacter, Count:=-1
            CheckID = rngTable.Text
            If CheckID <> "ID" Then
                Selection.MoveUp Unit:=wdLine, Count:=1
 
                While Selection.Information(wdWithInTable) = False
                    Selection.MoveUp Unit:=wdLine, Count:=1 'moves up until it hits the end of the first part of the table
                Wend
 
                Selection.MoveDown Unit:=wdLine, Count:=1
 
                While Selection.Information(wdWithInTable) = False
                    Selection.Delete Unit:=wdCharacter, Count:=1
                Wend
            End If
        Next
    'start over at the beginning.  There are fewer tables now...each starts with "ID"
    Selection.HomeKey Unit:=wdStory 'start at the beginning of the document
 
    If Selection.Information(wdWithInTable) Then Selection.splittable 'make sure there's a spot for the first heading
    For Each tblDoc In ActiveDocument.Tables
        If tblDoc.Columns.Count = 4 Then
            tblDoc.Range.Columns(3).Select
            Selection.MoveRight Unit:=wdCharacter, Count:=1, Extend:=wdExtend
            Selection.Cut
            While Selection.Information(wdWithInTable)
                Selection.MoveDown Unit:=wdLine, Count:=1
            Wend
            Selection.PasteAppendTable
            'now the table only has 2 columns, with FieldName in column 1 and content in column 2
            'get rid of empty rows
            For Each tblRow In tblDoc.Rows
                tblRow.Select
                If Selection.Characters.Count = Selection.Words.Count Then Selection.Rows.Delete
            Next
        End If
    Next
    End If
 
End Sub
Sub MakeHeaders()
'For each table, put a numbered heading 3 above it
Dim tblDoc As Table
For Each tblDoc In ActiveDocument.Tables
    tblDoc.Cell(1, 1).Range.Select
    Selection.MoveUp Unit:=wdLine, Count:=1
    If Selection.ParagraphFormat.Style <> "Heading 3" Then
        Selection.ParagraphFormat.Style = "Heading 3"
    End If
Next
 
End Sub
Sub AddHeadingStyles()
'
' AddPStyle Macro
'
'
    With ActiveDocument.Styles("Heading 3").Font
        .Name = "Arial"
        .Size = 18
        .Bold = False
        .Color = wdColorAutomatic
    End With
 
    Selection.Style = ActiveDocument.Styles("Heading 3")
    With ListGalleries(wdOutlineNumberGallery).ListTemplates(1).ListLevels(1)
        .NumberFormat = "%1"
        .TrailingCharacter = wdTrailingTab
        .NumberStyle = wdListNumberStyleArabic
        .NumberPosition = InchesToPoints(0)
        .Alignment = wdListLevelAlignLeft
        .TextPosition = InchesToPoints(0.3)
        .TabPosition = wdUndefined
        .ResetOnHigher = 0
        .StartAt = 1
        With .Font
            .Bold = True
            .Italic = False
            .StrikeThrough = False
            .Color = wdAutomatic
            .Size = 18
            .Name = "Arial"
        End With
        .LinkedStyle = "Heading 1"
    End With
    With ListGalleries(wdOutlineNumberGallery).ListTemplates(1).ListLevels(2)
        .NumberFormat = "%1.%2"
        .TrailingCharacter = wdTrailingTab
        .NumberStyle = wdListNumberStyleArabic
        .NumberPosition = InchesToPoints(0)
        .Alignment = wdListLevelAlignLeft
        .TextPosition = InchesToPoints(0.4)
        .TabPosition = wdUndefined
        .ResetOnHigher = 1
        .StartAt = 1
        With .Font
            .Bold = True
            .Italic = False
            .StrikeThrough = False
            .Color = wdAutomatic
            .Size = 18
            .Name = "Arial"
        End With
        .LinkedStyle = "Heading 2"
    End With
    With ListGalleries(wdOutlineNumberGallery).ListTemplates(1).ListLevels(3)
        .NumberFormat = "%1.%2.%3"
        .TrailingCharacter = wdTrailingTab
        .NumberStyle = wdListNumberStyleArabic
        .NumberPosition = InchesToPoints(0)
        .Alignment = wdListLevelAlignLeft
        .TextPosition = InchesToPoints(0.5)
        .TabPosition = wdUndefined
        .ResetOnHigher = 2
        .StartAt = 1
        With .Font
            .Bold = True
            .Italic = False
            .StrikeThrough = False
            .Color = wdAutomatic
            .Size = 18
            .Name = "Arial"
        End With
        .LinkedStyle = "Heading 3"
    End With
    ListGalleries(wdOutlineNumberGallery).ListTemplates(1).Name = ""
    Selection.Range.ListFormat.ApplyListTemplateWithLevel ListTemplate:= _
        ListGalleries(wdOutlineNumberGallery).ListTemplates(1), _
        ContinuePreviousList:=False, ApplyTo:=wdListApplyToWholeList, _
        DefaultListBehavior:=wdWord10ListBehavior
End Sub
 
Upvote 0
Re: Word format Macro help

Hi Cindy,

Thank you a lot for all the efforts. I think i missed out something but when i run those macros, i get errors and probably dependent on each the output is the 4 different tables with a blank row as seperate table. Please let me know what mistake i am doing.

Firstly to clarify your questions.
1. There are not four coloumns in all the rows. There 4 fields for which an additional two coloumns are embedded in the table and other two rows are are 2 column ones. I am sorry, i wasn't aware, logic would be based on that.
In the end of table there is one two column field "Description" with one next column empty and it's data in the next single row . .without columns.

List of errors:

1. Sub AddHeadingStyles() line 170, col 25
ApplyListTemplateWithLevel Method or Data member not found (Error 461)
Selection.Range.ListFormat.ApplyListTemplateWithLevel ListTemplate:= _

2. Sub FixTables() line 52, col 29
.MoveEnd Error Method or Data member not found (Error 461)
rngTable.MoveEnd Unit:=wdCharacter, Count:=-1

3. AddHeadingStyles() line 120, col29
ApplyListTemplateWithLevel Error Method or Data member not found (Error 461)
Selection.Range.ListFormat.ApplyListTemplateWithLevel ListTemplate:= _

Thanks in Advance
 
Upvote 0
OK...we'll take a couple of steps back.
First, which version of Word are you using? I think the errors with AddHeadingStyles might be due to differences between versions of Word. If I have access to the version you have I'll work out the right syntax for that version.
Second, for each ID (and its associated data), is the layout reasonably consistent? If so, can you describe each row that has data? (I don't care about blank rows, since those will get deleted)
For instance,
Row 1: ID and name, 4 columns ?
Row 2: Department, 4 columns (2 with data, 2 empty), or just 2 columns with nothing to the right ?
Row 3: Due Date, 4 columns (2 with data, 2 empty) , or just 2 columns with nothing to the right?
Row 4: Description, 2 columns, 1 empty
Row 5: description data, 1 cell? or not in a table at all?

If the format isn't consistent, is it (at least) always the case that the field name is just to the left of the associated data, except for Description, in which case the data is below the label?

Cindy
 
Upvote 0
Hi Cindy,

Thank you very much.

1. I am using Microsoft word 2003 this moment, SP3. But i am concerned that this others may have been using word 2010, i am sure it's a matter of time every one get that upgrade. So happy to lock the answer as 2003 for the moment.

2. For cality, i will copy the table again.
<!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width:100.0%;border-collapse:collapse;mso-padding-alt:0cm 0cm 0cm 0cm" border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td colspan="2" style="width:100.0%;border:solid #CCCCCC 1.0pt; mso-border-alt:solid #CCCCCC .75pt;background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="100%"> [ID-IH01] Record details Created: 14/Apr/11 Modified: 14/Apr/11

</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Status:
</td> <td style="width:80.0%;border-top:none;border-left: none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="80%"> Open
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Dept:
</td> <td style="width:80.0%;border-top:none;border-left: none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="80%"> Accounts
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="border:solid #CCCCCC 1.0pt;border-top:none;mso-border-top-alt: solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt;background:white; padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> Division:
</td> <td style="border-top:none;border-left:none;border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt;mso-border-top-alt:solid #CCCCCC .75pt; mso-border-left-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> Research
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="border:solid #CCCCCC 1.0pt;border-top:none;mso-border-top-alt: solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt;background:white; padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> policy:
</td> <td style="border-top:none;border-left:none;border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt;mso-border-top-alt:solid #CCCCCC .75pt; mso-border-left-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> None
</td> </tr> <tr style="mso-yfti-irow:5;mso-yfti-lastrow:yes"> <td style="border:solid #CCCCCC 1.0pt;border-top:none;mso-border-top-alt: solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt;background:white; padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> Linked policies:
</td> <td style="border-top:none;border-left:none;border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt;mso-border-top-alt:solid #CCCCCC .75pt; mso-border-left-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> None
</td> </tr> </tbody></table>
<table class="MsoNormalTable" style="width:100.0%;border-collapse:collapse;mso-padding-alt:0cm 0cm 0cm 0cm" border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; mso-border-alt:solid #CCCCCC .75pt;background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Type:
</td> <td style="width:30.0%;border:solid #CCCCCC 1.0pt; border-left:none;mso-border-left-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="30%"> Salary
</td> <td style="border:solid #CCCCCC 1.0pt;border-left:none;mso-border-left-alt: solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt;background:#F0F0F0; padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top"> Contact:
</td> <td style="border:solid #CCCCCC 1.0pt;border-left:none; mso-border-left-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top"> 01 234 23466
</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Reporter:
</td> <td style="width:30.0%;border-top:none;border-left: none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="30%"> Andrew
</td> <td style="width:20.0%;border-top:none;border-left: none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Joined date:
</td> <td style="width:30.0%;border-top:none; border-left:none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top" width="30%"> June 20 2010
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Resolution:
</td> <td style="width:30.0%;border-top:none; border-left:none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top" width="30%"> Unresolved
</td> <td style="width:20.0%;border-top:none;border-left: none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> References:
</td> <td style="width:30.0%;border-top:none; border-left:none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top" width="30%"> John
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Labels:
</td> <td colspan="3" style="border-top:none;border-left:none; border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top"> None
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Remaining Estimate:
</td> <td colspan="3" style="width:80.0%;border-top: none;border-left:none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top" width="80%"> Not Specified
</td> </tr> <tr style="mso-yfti-irow:5"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Time Spent:
</td> <td colspan="3" style="width:80.0%;border-top: none;border-left:none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top" width="80%"> Not Specified
</td> </tr> <tr style="mso-yfti-irow:6"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%"> Original Estimate:
</td> <td colspan="3" style="width:80.0%;border-top: none;border-left:none;border-bottom:solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt; mso-border-top-alt:solid #CCCCCC .75pt;mso-border-left-alt:solid #CCCCCC .75pt; mso-border-alt:solid #CCCCCC .75pt;background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" nowrap="nowrap" valign="top" width="80%"> Not Specified
</td> </tr> <tr style="mso-yfti-irow:7;mso-yfti-lastrow:yes"> <td style="width:20.0%;border:solid #CCCCCC 1.0pt; border-top:none;mso-border-top-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:#F0F0F0;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top" width="20%">
</td> <td colspan="3" style="border-top:none;border-left:none;border-bottom: solid #CCCCCC 1.0pt;border-right:solid #CCCCCC 1.0pt;mso-border-top-alt:solid #CCCCCC .75pt; mso-border-left-alt:solid #CCCCCC .75pt;mso-border-alt:solid #CCCCCC .75pt; background:white;padding:1.35pt 1.35pt 1.35pt 1.35pt" valign="top">
</td> </tr> </tbody></table>
<table class="MsoNormalTable" style="width:100.0%;border-collapse:collapse;mso-padding-alt:0cm 0cm 0cm 0cm" border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes"> <td style="background:white;padding:0cm 0cm 0cm 0cm">
</td> </tr> </tbody></table>
<table class="MsoNormalTable" style="width:100.0%;mso-cellspacing:0cm;mso-padding-alt:1.5pt 1.5pt 1.5pt 1.5pt" border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes"> <td style="width:1.0%;background:#BBBBBB;padding:1.5pt 1.5pt 1.5pt 1.5pt" nowrap="nowrap" width="1%">
Description​
</td> <td style="padding:1.5pt 1.5pt 1.5pt 1.5pt">
</td> </tr> </tbody></table>​

<table class="MsoNormalTable" style="width:100.0%;mso-cellspacing:0cm;mso-padding-alt:0cm 0cm 0cm 0cm" border="0" cellpadding="0" cellspacing="0" width="100%"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes"> <td style="border:solid #CCCCCC 1.0pt;mso-border-alt:solid #CCCCCC .75pt; padding:1.35pt 1.35pt 1.35pt 1.35pt"> Employee joined in June 2010, dept of accounts.

</td> </tr> </tbody></table>
<hr align="center" size="14" width="100%"> ​
The above has to be converted to a simple table format removing the 1. Picture frame which is just above this text 2.Removing blank lines 3.making it a simple one table with as many rows as data with field and data (2 columns).


The multiple data is the "Contact", "Joined Date ", "References" fields and table format. This breaks the import to the application as it requires a simple two column field and data.



Likewise 100s of such tables. Now i will leave to you to find the delimiter as entire set up is one record.


The above needs to convert to the following.


1.1.1 ( This must be header 3 )


<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} table.MsoTableGrid {mso-style-name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-border-insideh:.5pt solid windowtext; mso-border-insidev:.5pt solid windowtext; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400;} </style> <![endif]-->
<table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:221.4pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> ID:
</td> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> [ID-IH01]
</td> </tr> <tr style="mso-yfti-irow:1"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Text:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Record details
</td> </tr> <tr style="mso-yfti-irow:2"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Created:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> 14/Apr/11
</td> </tr> <tr style="mso-yfti-irow:3"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Modifier:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> 14/Apr/11
</td> </tr> <tr style="mso-yfti-irow:4"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Status:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Open
</td> </tr> <tr style="mso-yfti-irow:5"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Division:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Research
</td> </tr> <tr style="mso-yfti-irow:6"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Policy:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:7"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Linked Policies:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:8"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Type:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:9"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Reporter:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:10"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Resolution:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:11"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Labels:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:12"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Remaining Estimate:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:13"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Time Spent:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Not Specified
</td> </tr> <tr style="mso-yfti-irow:14"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Original Estimate:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Not Specified
</td> </tr> <tr style="mso-yfti-irow:15"> <td style="width:221.4pt;border:solid windowtext 1.0pt;border-top: none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" width="295"> Description :
</td> <td style="width:221.4pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" width="295">
</td> </tr> <tr style="mso-yfti-irow:16"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Contact:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:17"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Joined date:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:18"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> References:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> <tr style="mso-yfti-irow:19;mso-yfti-lastrow:yes"> <td style="width:221.4pt;border:solid windowtext 1.0pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295"> Comments:
</td> <td style="width:221.4pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="295">
</td> </tr> </tbody></table>

I am not sure if i have given data to get help. I am really thankful to you.


Thanks in Advance.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
920
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M

Forum statistics

Threads
1,224,518
Messages
6,179,259
Members
452,901
Latest member
LisaGo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top