Exporting Summarized Data to Word

[FatMacMan]

yes, we are still on FMP6. No, they wont pay for the 200 client update for at least another year. Sigh.

Anyway... I have a little solution put together that tracks responses to post seminar evaluation forms (How useful was this class [1] [2] [3] [4] [5])... exciting stuff... anyway, my big weakness is figuring out how to export a summarized report out to a text or Word file for "The Powers That Be

[transpower]

Consider printing the summary report to a PDF. If they really need to convert from PDF to Word, they can, using any number of utility programs.

[DykstrL]

Here's a quick and dirty way to do this. Setup a global text field. Then with a script copy and format your report data into HTML. In the script create a found set of 1 record - it doesn't matter which one - and export just the one global field to a TAB file, but as part of the script make the extension ".DOC". The file will open in Word that can be formatted just like an HTML file.

It will take some trial and error to get the HTML code just right (some of that coding will be really ugly) so Word will display the text correctly, but once you figure that out the report in Word can be created by one click on a button.

I have attached an example of a "Word" document created in this manner. It has formatted text, and even hyper links.

Example.zip

[FatMacMan]

hey... thanks for your help... ill give both solutions a try and see what works! Thanks!