acFormatPDF

[DFASWood]

I am using the following code to send email reports in PDF format in Access
2007.

DoCmd.SendObject acReport, "ReporttoemailalldatawFamLv", acFormatPDF,
Myemail, "", "", "FOUO Leave Availability Report for CSRGroup " & MyCSRGroup
& " As Of " & MyAsOFDate, "THIS REPORT CONTAINS INFORMATION SUBJECT TO THE
PRIVACY ACT OF 1974 AS AMENDED." & myemailmess, False, ""

I have a user that has Access 2007 loaded that gets "format can not be run"
error when she trys to send these reports. My beta test site had no
problem with this line of code and was able to send the reports without error.

Is there a setting that might be impacting the successful use of this line
of code?

 

[Albert D. Kallal]

I suspect the problem is that that person does not have the pdf at
installed.

Because of a thread of lawsuits by the Adobe people, Microsoft was unable to
include PDF ability as a built in, and therefore you must undertake a
separate download to enabled PDF creation ability in office.

you can find this download here

http://www.microsoft.com/downloads/...3C-6D89-4F15-991B-63B07BA5F2E5&displaylang=en

without the added installed, office cannot create pdf files.

So install the download, and remember to thank the people at Adobe for such
a stupid move on their part...

 

[tdhilltx]

Thanks for this information. I tried for hours figuring out why the OutputTo method wouldn't work even though I had the Adobe add-in installed. After I ran this .exe the code worked like a charm. I've wanted for years to render a report as pdf and view it inside a subform within Access. Now I can do it using this method and the IE browser control. Thanks a lot.