Scripting printing to PDF

[Preka]

I have a form that is essentially printable paperwork. At present, it gets automatically faxed to customers, but I'd like to add email as an option.

I have the scripting handled for pulling the email address and passing it through to Outlook, including the attachment. The only problem is printing the form to PDF itself. It's handled easily enough with a small amount of human interaction, but I'd like to script that out if possible.

At present, when the print command is executed, the save file window pops up and asks for a file name/location. Is there any way I can script around this so that the filename and save location are automatically entered?

 

[Remou]

I have use PDFCreator with some success. I have also heard good things about CutePDF.

 

[Preka]

I'm using cutePDF already, actually. The problem isn't getting the file into PDF format - that's easy enough. I just want to do it by way of VBA script without any human interaction (entering a file name, save location, hitting save, etc.) beyond "click the button".

 

[Remou]

Have you the custom CutePDF, from the FAQ:

http://www.acrosoftware.com/Solutions/pdfwriter.asp

This is a list of PDF creators that can be automated:

http://www.granite.ab.ca/access/pdffiles.htm

 

[jrbarnett]

You don't say which version of Office you are using, but there's a guide to scripting the free PDF creator addon for Office 2007 at thread705-1491465

John

 

[SeeThru]

There is a great function on Stephen Lebans access page - ConvertReporttoPDF. Takes any snapshot file, and converts flawlessley to PDF. As Access can easily create a snapshot file, you can create the snapshot, convert it and output the resulting PDF to email. Free!



SeeThru
Synergy Connections Ltd - Telemarketing Services