Report to word doc

Hi

Is it possible to programmatically run a report and have the results saved
in a word file on disk? I also need the saved filename as I need to attached
it to an email in the next step.

Thanks

Regards

ADezii

Quote:

Originally Posted by John

Hi

Is it possible to programmatically run a report and have the results saved
in a word file on disk? I also need the saved filename as I need to attached
it to an email in the next step.

Thanks

Regards

'A Report can be saved in a .rtf format which Microsoft Word can read
'To save rptEmployee to Test.rtf in the C:\Dell\ directory:
DoCmd.OutputTo acReport, "rptEmployee", "RichTextFormat(*.rtf)", "C:\Dell\Test.rtf", False, "", 0

John,

Have you tried DoCmd.OutputTo, which supports rich text file output?
You can include the output path and filename, giving you access to the
information immediately.

- GH

>From access you can open word and put data easily into a "Bookmark". I
have never tried to dump a whole report into a bookmark, but it may be
possible. This requires a master that you have defined the bookmark in
before it is used as output.

On the surface the rtf format sounds cleanest right now.

Report to word doc

re: Report to word doc

re: Report to word doc

re: Report to word doc

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about