Export reports in PDF format

  • Thread starter Thread starter AlCamp
  • Start date Start date
A

AlCamp

I'd like to convert some of my Access reports to PDF format, and send them
to customers via SendObject.

I've found several products on the web that I'm trying to evaluate... but...

Can anyone recommend add-in software that does what I need, and that they've
used in the past with good results?

Thanks in advance,
Al Camp
 
Jason,
Thanks for that link. Now that I've learned a bit more about PDF and
Access, I think I'm really looking for a way to use Access's SendObject, but
with a PDF format option.
I think most of the Access/PDF apps just output an normal Access report
to an external .PDF file via a "PDF Printer". Then the external PDF would
have to be attached to an email and sent to the customer.
I really need to try to do all this within Access via the SendObject
function.

Perhaps that's not do-able, but I'd like to check that out thoroughly
before I take another tack.

Thanks for your help,
Al Camp
 
Al,

There's a library from ACG that we use to generate
individual pdfs (one per record) from a report. Works ok.
It has an email facility too which we don't have a need
for - so I can't comment on that part of the system.

Have a look at:

http://ourworld.compuserve.com/homepages/attac-
cg/acgsoft.htm

It was pretty cheap tooo!

HTH,

Terry
 
Download a program called PDFEdit995 and (www.pdf995.com) and it will allow
you to convert a report into a pdf file. It also has the facility to attach
the pdf file to an email.
 
Terry,
I wrote a thank you for your suggestion, but it bounced, so I'll try
again.
I'll check that out for sure...
Thanks
Al Camp
 
PC,
Yes, it looks as though I'll be trying PDF995 first.
I also checked out CutePDF Writer, but it didn't appear to have the mail
functionality that PDF995 has.
Thanks for the info...
Al Camp
 
I'm looking to do the same thing - send an Access report via email in
PDF format. Did PDF995 do the trick?
 
You could use our Batch Reporting Module product.

We sell the source code to create pdf files (for use with either Adobe
PDFWriter or win2pdf drivers).

We have an example of using a third party mail component to send email
(ASPMail from www.serverobjects.com).

It might not be the cheapest approach but probably the best.

Basically when picking a pdf driver you need to get into the details of
exactly how the pdf
file is made. The drivers do vary in the functionality they have, however
simple reports probably work
from any of the drivers. The guys at win2pdf could probably tell you why
they think there pdf driver is better?

When picking a way to send email, some products automate through CDONTS,
some use say the SMTP
service built into IIS and some have implemented there own code. I know
ASPMail has been around for years
and has tons of customers (requires one extra DLL to sit next to your Access
database).

Our batch reporting module code is just some Access source code that makes
it easy to control the pdf drivers
that we support through manipulating the registry etc.... It also has some
features like dynamic query changes
and where clause options before the report/pdf is created.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
 
Back
Top