Hi , I have a report that I am converting to PDF using the OutputTo action in a macro.
The report is for A4 viewing by customer to be sent via email later.
The document is a letter so it must have our comany letterhead image at the header. I have created the image in photoshop 300dpi 700px by 133px, so that when inserted into the report in design view is it the correct size without resizing. This image looks fine when viewing the report out of design view.
The problems comes after the report is saved as PDF by the macro command at the file location. When I Open the new PDF the image quality of the header image has degraded quite a lot, it must have been compressed during the process.
Does anyone know a fix or workaround or done in VBA that would prevent the PDF being generated in a "optimised" format. I figure there must be a default level of compression set - which is making my letterhead image coming out with loss of data. ??
Im using Access2007 with the Save as PDF Add in installed.
also
the Output File line in the macro im using is
\\NASDrive\share\clientfolder\TESTING\& [surname]&[Quoteref]&".pdf"
im trying to get it to make the file name to pull data from the surname and quoteref field on the form. Cant get it to work in the macro. What is the correct way to reference it ? ?
any help would be really apreciated
thankss
J
The report is for A4 viewing by customer to be sent via email later.
The document is a letter so it must have our comany letterhead image at the header. I have created the image in photoshop 300dpi 700px by 133px, so that when inserted into the report in design view is it the correct size without resizing. This image looks fine when viewing the report out of design view.
The problems comes after the report is saved as PDF by the macro command at the file location. When I Open the new PDF the image quality of the header image has degraded quite a lot, it must have been compressed during the process.
Does anyone know a fix or workaround or done in VBA that would prevent the PDF being generated in a "optimised" format. I figure there must be a default level of compression set - which is making my letterhead image coming out with loss of data. ??
Im using Access2007 with the Save as PDF Add in installed.
also
the Output File line in the macro im using is
\\NASDrive\share\clientfolder\TESTING\& [surname]&[Quoteref]&".pdf"
im trying to get it to make the file name to pull data from the surname and quoteref field on the form. Cant get it to work in the macro. What is the correct way to reference it ? ?
any help would be really apreciated
thankss
J
Last edited: