Hello,
I have had users entering information into a database driven application to generate narrative student report cards. I had them using the basic rich text box for editing, etc.
It has come time where I want to transfer all of that into a report to print and mail to the parents. I am currently exporting the database in order to do a mail-merge with Microsoft Word. The problem is that Microsoft Word removes all of the rich formatting. I also tried putting it in to Microsoft Access to do a report that way. The problem then was that all the formatting was shown as plain text with formatting tags. The tags were not shown in the Microsoft Word route.
I guess this stems to a deeper problem. I need sort of an immediate fix as these reports need to be generated relatively quickly and I would like to include the rich formatting. In the long-term the organization I am working for would like a more automated form of reporting that doesn't require so much intervention.
Sample entries might appear like the following:
<META content=Word.Document name=ProgId><META content="Microsoft Word 10" name=Generator><META content="Microsoft Word 10" name=Originator><LINK href="file:///C:%5CDOCUME%7E1%5CAPUTZK%7E1.VER%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml" rel=File-List><STYLE><!-- / Style Definitions / p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; mso-hyphenate:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-fareast-language:AR-SA;}@page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;}div.Section1 {page:Section1;}--></STYLE><P class=MsoNormal>Joseph has not demonstrated more than a basic level of understanding of the subject matter in Earth Science.<SPAN> </SPAN></P>
Any ideas on how I can preserve that? If I do an export to Microsoft Word from the PHPRunner scripts it shows it in a table in Word with the correct formatting and no visible tags. The problem is that I need to take it from a table form and convert it to a report for each individual so that they can be distributed.
Thank you,
Joseph Irvine