Document from Query Results

[Riversidos]

I have a way to create an Excel Spreadsheet from a query result but how would I create a Word Document from a query result?

<cfsetting enablecfoutputonly="Yes">
<cfheader name="Content-Disposition" value="inline; filename=xs.xls"> 
<cfcontent type="application/msexcel" file="xs.xls">

<cfoutput>
    <table cols="4">
        <cfloop query="QryGetQueryList">
            <tr>
                <td>#QryGetQueryList.Company#</td>
                <td>#QryGetQueryList.Country#</td>
                <td>#QryGetQueryList.State#</td>
            </tr>
        </cfloop>
    </table>
</cfoutput>

 

[Helen267]

I've done this numerous times.

Format your page as you would like it to appear in MS Word (including fonts, highlighting, etc.) then add the following code AFTER your cfoutput end tag, but before your body tag:

<CFHEADER NAME="Content-Type" VALUE="application/msword">
<CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=msword.doc">

 

[Helen267]

Sorry, that should read:

AFTER your cfoutput end tag, but BEFORE your body END tag