Merge to Word

[mrsjoan]

I want to move save an Access Report as a WORD Document. I need it to either
merge into a predefined table in WORD or just save the report with the table
set -- the actual borders of the table showing in the Access report--as a
WORD document. Can either of these ways happen?

Thanks,
mrsjoan

 

[John Nurick]

Hi Mrs J,

Access's built-in tool for exporting a report to Word is rather limited
and does not produce well-structured Word documents. There are some
alternatives here: http://www.lebans.com/ReportUtilities.htm

If possible, however, I'd export a query rather than a report. In recent
versions of Word, if you use the query as the data source for a Word
{DATABASE} field you can get a table with one of the standard Word table
autoformats plus a bit of manual overriding (see Word help on "Field
Codes: Database Field"). You can also use the query as the data source
for merging (a "catalog" rather than a "form letter").