Printing non-Office file to default printer

[Dkline]

I need to print a PDF file to the default printer. PDF is already created.

Path and filename are in a table. Access will create a form letter in Word,
print that, and then it needs to print the PDF which has the backup
information. (These PDFs come from various suppliers.)

Can I do this?

 

[david epsom dot com dot au]

Unless you have a printer that understands PDF files (rare
if not unknown), you need a program to render the PDF file
to a printer canvas.

Many PDF viewers and printer drivers can be automated to
do this. You need to select a PDF viewer or File Printer
and then look at it's help files to see what to do.

Do that, then if :~) you have questions about how to follow
the instructions using Access, post those questions here.

(david)

 

[Dkline]

I have both Distiller and PDFWriter installed as printers. I can open the
Adobe file in Adobe automatically. I just can't get it to print without user
intervention. I've even tried SendKeys but can't seem to get the syntax
right on the SendKeys.

 

[david epsom dot com dot au]

I'm not familiar with either Distiller or PDFWriter, but a
quick look on the web tells me that Distiller doesn't print.
And I don't see any automation instructions for PDFWriter.
(Although there are several products with that descriptive
name)

If you have Acrobat, you can automate that, or you can use
DDE, or you can shell to Acrobat and use a command line,
or you ?tell Acrobat to run a 'sequence'?

I don't know the SendKeys sequences for Acrobat: I think you
need to ask these questions in an Acrobat forum first.

(david)

 

[Dkline]

I may try adding a ShellExecute to see if that works. As suggested I'll give
Adobe a chance to tell me the syntax for SendKeys to print an open file.