Printing to pdf from Access Application

[Ted]

Hi all,

My company is currently printing out our policies & mailing them out. We
would like to print our policies to pdf. We have the full version of Adobe
Acrobat Professional and NitroPDF. Without going into too much detail my
access policy issuance program opens up word & prints out the required
documents. how can i have them print directly to one pdf document? any
direction would be very much appreciated.

Ted

 

[M Skabialka]

You can do this from Office 2007 using this add-in, without the need for
Adobe or any other pdf creator.
2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS
http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

Mich

 

[ken]

Ted:

In earlier versions the simplest option is to install a PDF virtual
printer such as Cute PDF from:

http://www.cutepdf.com/

You can then just print the report via the normal print dialogue,
specifying Cute PDF as the printer. It will then open a dialogue for
entering the file name and create a PDF file. To automate the process
you can use Stephen Lebans utility available from:

http://www.lebans.com/reporttopdf.htm

This does not require a PDF printer to be installed.

Ken Sheridan
Stafford, England

 

[Ted]

Thank you Ken. I'll look at that now.

here is a snippet of my code

Set objWord = GetObject(, "Word.Application")
notloaded8:
If Err.Number <> 0 Then
Set objWord = CreateObject("Word.Application")
End If
objWord.Visible = True
objWord.Documents.Open FileName:="L:\Glencoe\Policies\" & txtPolNumber &
".doc"
objWord.ActiveDocument.PrintOut
objWord.ActiveDocument.PrintOut

Set objWord = Nothing

when it opens the document it prints it to the printer. there will be
several documents to follow after this first one. I need to have all of them
saved to one pdf file. can anyone point me in the right direction as far as
syntax? also i don't want it to prompt me for a file name to save to.

TIA
Ted

 

[ken]

Ted:

While I've done a fair bit of Access to Word automation I'm afraid I'm
not very familiar with the Word object model, but if you use the Cute
PDF printer for instance I think you'd need to add the following line
before calling the active document's PrintOut method to send it to a
PDF file:

objWord.ActivePrinter = "CutePDF Writer"

However, this would send each document to a separate PDF file. I
don't know enough about Word to say how you'd automate sending
multiple documents to a single PDF file. You might find you'd get a
better response to that in the Word newsgroup.

Ken Sheridan
Stafford, England