Hide Printing notification (1 Viewer)

Gismo

Registered User.
Local time
Today, 09:31
Joined
Jun 12, 2017
Messages
1,298
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

Well-known member
Local time
Today, 03:31
Joined
Apr 9, 2015
Messages
4,339
did you try: docmd.SendTo ....

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

Gismo

Registered User.
Local time
Today, 09:31
Joined
Jun 12, 2017
Messages
1,298
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 *"

1621248375739.png



1621248395422.png
 
Last edited:

Users who are viewing this thread

Top Bottom