E-mail with Report as PDF attachment

[utzja1]

I built a database for a client using Access 2010; the client is using Access 2003 to run the database. One of the macro buttons that I built into all the reports is supposed to create a new e-mail message with the report attached in PDF format. Here is the language that I used:

DoCmd.SendObject acReport, "Report", "PDFFormat(*.pdf)", "", "", "", "Asset Management System: Report", "Please see the attached report.", True, ""

When I click the macro button in Access 2010, I have no problems with it. When the client does the same in Access 2003, they get an error message that the output format is not supported. When i changed the SendObject output format to rich-text, the report is attached to the e-mail but the formatting is much simpler. Is there any work-around with Access 2003 to get the pdf export to work?

Many thanks for your consideration.

 

[pbaldy]

PDF was not supported in 2003. Many of us used this:

http://www.lebans.com/reporttopdf.htm

 

[utzja1]

Thanks, it's good to know that. i thought it just might not be supported but wanted to make sure it wasn't a missing object library or some such thing.

My company's security policy is blocking me from downloading the zip file, but I do appreciate the quick reply.

 

[pbaldy]

No problem. I think some people used a PDF print driver to create the PDF files, so that's certainly not the only option.