Format a PDF document sent from MS Access

[sydc]

Hi,

Is it possible to format a PDF document created in MS Access i.e. set the document to landscape instead of portrait as in the following code;

DoCmd.OutputTo acOutputQuery, "Query Name", acFormatPDF, "Document Name", False

This PDF document is attached to an MS Outlook e-mail and sent without any intervention from the user. This is accomplished using further VBA code. This code is working at the moment sending both Excel spread sheets and PDF documents but the PDF's require the page formatting before sending. I want to be able to accomplish this without having to open another application such as Adobe Acrobat.

Kind regards,

Syd.

 

[pr2-eugin]

Hello sydc, welcome to AWF.

As far as I am aware, you will not be able to do this without using Adobe Acrobat Object. I might be wrong.

Have you tried creating the Query as a Report, setting the Orientation, then exporting the Report instead of Query?

 

[sydc]

Hi Paul,

Thanks for the info, that worked great. Created the required reports for the queries, formatted the report then created the report in PDF and attached the MS Outlook mail.

Thanks again,

Regards,
Syd Champkin.

 

[pr2-eugin]

Glad I could be of help. Good Luck