Export reports in PDF format

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
 
A

AlCamp

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
 
T

Terry

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
 
P

PC Datasheet

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.
 
A

AlCamp

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
 
A

AlCamp

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
 
M

mfischer

I'm looking to do the same thing - send an Access report via email in
PDF format. Did PDF995 do the trick?
 
M

Mark Andrews

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top