Is it possible to create a report without previewing or printing it?

O

Opal

I want to be able to create a report but I do not want to preview it
or print it. I want simply to
output it to an .rtf file for emailing. The report runs off of a
query but running the query only does not solve my issue.

Is there a way to accomplish this?

Thank you.
 
F

fredg

I want to be able to create a report but I do not want to preview it
or print it. I want simply to
output it to an .rtf file for emailing. The report runs off of a
query but running the query only does not solve my issue.

Is there a way to accomplish this?

Thank you.
Click to expand...

Look up the OutputTo method in VBA help

DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF,
"c:\YourFolderName"

Be aware that reports sent as .rtf files lose their graphics.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print (physical or pdf) not respecting format of source document 0
Is it possible to edit colours already saved as part of a custom theme? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Search using a combo box and then creating a report. 4
How to remove a bracket that is itallicised for an entire document 1
Documents Not Appearing (as it used to) On Desktop ? [on a Mac] 0
Print a report without displaying print preview 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top