Exporting to PDF

[teiben]

Any ideas how this can be accomplished or if? I'm running Access 97 (w/XP) and I have many reports which get emailed as a RTF, which is fine, but can this be done with Adobe? I own Adobe 6.0 professional. Currently the code I'm using is

tDocName = "InterimStatus"
'DoCmd.SendObject acSendReport, stDocName, acFormatRTF, "bbenny", , "teiben", "PPAP Interim Status Report - BB's responsibility", , False

when I try and replace the acFormatRTF w/acFormatPDF I get an error.

 

[mlh407]

Try using Crytal Reports. Via it you can export to PDF

 

[Hayley Baxter]

There is si=ome sample code to do this at the link below.

Export report output as PDF

Hay