By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Report to word doc

P: n/a
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
May 24 '06 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,638
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
May 24 '06 #2

P: n/a
GH
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

May 24 '06 #3

P: n/a
>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.

May 25 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.