New Forum | Previous | Next | (P-PDF) Developers

Topic: Access Report to PDF File to Email Attachment
Conf: (P-PDF) Developers, Msg: 51193
From: bruntosj
Date: 5/29/2002 04:43 PM

Hello all,

Great site, looks like a lot of useful information is here.

I've been assigned the task of finding a tool (or, if necessary, creating the tool) to export an Access report to a PDF file, for use as an attachment to an email. Currently, the email attachment is an RTF file, which is simply created by using the VBA command SendObject. However, SendObject (as far as I know) only supports HTML, Text, Excel, RTF, and SnapShot. First, is there a plug-in that can be purchased to add PDF to the file list? If not, is there a way that the active report can be converted to a PDF file, without much user intervention?

In a perfect world, here's what I would like the application to do:

1) The user opens the report in Print Preview mode. There's a toolbar button named "Email" that they click on.
2) The "Email" button magically takes the active report, converts it to a PDF file, launches the email software, and attaches the PDF file to it.
3) The user adds additional info to the email message, if desired, and clicks Send to send the email, or can cancel the operation at this point.

Number 2, is, of course, the key to all this. Has anything like this been done before?

Thanks in advance,

Scott