I am trying to send a report in PDF format to an established folder on computer. The folder path is
which I know is a real path because I debug.print it.
I really don't want to preview the report, just send it to the folder.
Here is my code:
DoCmd.OpenReport "rptBillOfLading", acViewPreview, , , acHidden
DoCmd.OutputTo acOutputReport, "rptBillOfLading", acFormatPDF, strClientAppealsAttachmentFolderDataPath
Open in new window
but I get an The OutputTo action was cancelled and the report preview but I don't want it to.
try first using FileCopy method to that location, see what happens.