Hide Printing notification (1 Viewer)

[Gismo]

Hi All,

In the email CDO code, I output the report to PDF.
When emailing the report, the printing page 1 of 2, 2 of 2 pops up
I would like to hide that popup but nit sore how or where to do this

I tried hiding the the pop up but then for some reason the actual report opened which I do not wat to do either.

'<<<<<<<<<<<<<<<<<<<<export the report as PDF>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
DoCmd.OutputTo acReport, "DAW Sheet", acFormatPDF, vReportPDF
'<<<<<<<<<<<<<<<<<<<<export the report as PDF>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


'<<<<<<<<<<<<<<<<<<call Colin's sub to email report as attachment>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
SendEMailCDO vRecipientList, scc, vSubject, vMsg, "", vReportPDF
'<<<<<<<<<<<<<<<<<<call Colin's sub to email report as attachment>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 

[Ranman256]

did you try: docmd.SendTo ....

but normally the pdf opens after creation (via pdf maker. set property to not open after complete)

 

[cheekybuddha]

Can you adapt the solution found here?

 

[Gismo]

did you try: docmd.SendTo ....

but normally the pdf opens after creation (via pdf maker. set property to not open after complete)

I did not try Sendto as OutputTo works fine
All I want to do is hide the pop up then it exports " Printing page * of *"