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

  • Thread starter Thread starter Opal
  • Start date Start date
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.
 
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.
 
Back
Top