Training database
I am looking to reduce pdf file sizes to a comparable size (as if printing through Adobe PDF Printer).
These pdf's are certificates and are sent via email to delegates who have attended a course. The certificates are branded with jpegs hence the large file size.
When I use the acFormatPDF to generate a report the size is approx 480mb. I can use the screen res switch on the command line and I get 390mb and start to lose quality.
If I print using Adobe's printer, I get high quality at 120mb.
I am wanting to have this function automated rather than print to pdf with adobe for each record.
Code used
DoCmd.OutputTo acOutputReport, "Rptexam", acFormatPDF, "C:\Users\public\temp\Course " & [CourseID] & " - exam.pdf", False
All files created are then grabbed by access and put in an email.
Any advice or a nudge in the directions of a solution?