A2007 How to output a PDF report

[JimS]

I've comleted work on the report and the popup form that allows the users to
filter the report. Now, I want to output the report (filtered) to .pdf file
and then ultimately email it.

I'm not seeing A2007 articles on this...can you guys point me in the right
direction?

 

[M.]

Dear Jim,

Follow the steps below:

1. install the pdf/xps plugin

2. use either the OutputTo command, e.g.

'Save filtered report as pdf file to disk
DoCmd.OutputTo acOutputReport, rpt.Name, acFormatPDF, strFileName
'Attach to email
myMailItem.attachments.add strFileName
olMailItem.Attachments.Add strFileName

3. or use the sendobject method, e.g.
Docmd.SendObject acSendReport,rpt.Name,acFormatPDF,ToEmailAddress

Good luck,

M.