OutputTo 2 locations at once

[supmktg]

I'm using the following code to save a PDF file to mapped Sharepoint drive.

DoCmd.OutputTo acOutputReport, "", acFormatPDF, strPDFPath & strPONum & ".PDF", False

The time it takes to format the PDF and save it to the Sharepoint drive is causing an issue with my next routine which attaches the PDF to to an email, as the file is not on Sharepoint in the time i takes to open my email form and search for the PDF file.

Is it possible to save a PDF file to both a mapped drive and a local drive in one OutputTo statement, so I can grab the PDF from the local drive to attach it?

I know I can run the statement twice, but I'm trying to minimize the time the user needs to wait for the PDF to get formatted and saved.

Any advice would be greatly appreciated,
Sup

 

[CJ_London]

Is it possible to save a PDF file to both a mapped drive and a local drive in one OutputTo statement

in short - no.

why not save to the local drive, send your email then copy to sharepoint?