Access 2000 Send as PDF

[D244153]

I have created a routine, that will send a report by email as a SNP file.

There is where the problem starts, not many users on the Network have
Snapshot Viewer, and IT do not want to install it on any other machines.

I want the report to be in a read only format, so SNP was perfect. Does
anyone know any other ways around this. OR/AND does anyone know how to
automate sending a report as a PDF file in access 2000.

Thanks

 

[Dirk Goldgar]

I have created a routine, that will send a report by email as a SNP file.

There is where the problem starts, not many users on the Network have
Snapshot Viewer, and IT do not want to install it on any other machines.

I want the report to be in a read only format, so SNP was perfect. Does
anyone know any other ways around this. OR/AND does anyone know how to
automate sending a report as a PDF file in access 2000.

You can create the PDF using Stephen Lebans' code here:

http://www.lebans.com/reporttopdf.htm
A2000ReportToPDF is an Access 2000 database containing
a function to convert Reports and Snapshot files to PDF documents.
No PDF Printer driver is required.

To attach the resulting PDF to an e-mail, though, you can't use
DoCmd.SendObject. Instead, you'll need to either automate the e-mail
program (if it supports it -- Outlook does, but not Outlook Express or
Windows Mail) -- or else use MAPI or CDO to create the message, attach the
file, and send it. Tony Toews has a good round-up of e-mail approaches
here:

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