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

"D244153" <(E-Mail Removed)> wrote in message
news:83F2CBB3-3C28-448E-98A6-(E-Mail Removed)...
>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


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)