Automatic printing.

[JPMontreal]

Hi,

I use Access to send information with Lotus note, it must be sent automatically. I print a report and e-mail it, it work find until for formatting raison we need to print the report with Acrobat.

I set Acrobat as the default printer on the computer where the e-mails are send.
Use the following code to print it:

Sub PrintRPT()
DoCmd.SetWarnings False
DoCmd.OpenReport "rptTasksWeb", acViewNormal
DoCmd.PrintOut
DoCmd.Close acReport, "rptTasksWeb", acSaveNo
DoCmd.SetWarnings True
End Sub

With it, a window popup and ask for the name of the acrobat file that will be created and it want to print as well the active form and ask for a name. Another procedure sends the rapport, This work well.

This must be automatic, so nobody will be there to answer the questions. How could I fix it?

Thanks,


Jean-Paul
Programmer.


Jean-Paul
Montreal
To send me E-Mail, remove “USELESSCODE”.
jp@USELESSCODEsolutionsvba.com