Save Report to File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My cmdUpdate button currently writes the data on my form to permanent tables.
I have a report which is then emailed to several parties. This is working
just fine. I would like also to be able to save that report to a folder on
my computer. I can't figure out quite how to do that last step. I thought
DoCmd.Save would be the right way to start, but that does not give me an
opportunity to declare the folder I would like to save it in. Any help would
be appreciated.
 
I'm assuming you send your report by e-mail using the SendObject method.

Here are 2 options (there are others)
1. use the OutputTo Method to export is as a snapshot (refer to the help for
more info and examples)
2. use lebans report2pdf to export it as a pdf
(http://www.lebans.com/reporttopdf.htm)
 
Back
Top