Emailing Snapshot format

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

AlCamp

In Access97, I'm looking for a method to email a complicated report directly
from Access.
The SendObject formats do not properly handle the text, subforms, and
charts, so I'm trying to use a PDF or Snapshot format.

Is there a acFormatSnp format for the SendObject funcion?

If not... what's a good method to use to do this? SendObject? OutputTo?

I tried PrimoPDF (a PDF Printer definition) but it only allowed me to save
the report as a file. Could I then send that file via email
"programatically"?

Or, is there a PDF converter out there that will convert a report to PDF,
AND email it as an attachment.

Thanks for any help,
Al Camp
 
AlCamp said:
In Access97, I'm looking for a method to email a complicated report
directly from Access.
The SendObject formats do not properly handle the text, subforms, and
charts, so I'm trying to use a PDF or Snapshot format.

Is there a acFormatSnp format for the SendObject funcion?
Click to expand...

In the newer versions, yes. In Access 97 use "Snapshot Format" (including the
quotes).
 
Rick,
Excellent... thanks a lot. Works like a champ!
I'm going to try to get the client to go with Snapshot Format, but they
may balk and go with PDF.
But, at least, with your info, I've got one way to get the report out
nailed down.

Thanks again,
Al Camp
 
You can use our batch reporting module to automate a process to:
- Create one or many pdf files
- create one or many emails with one or many pdf files as attachments

We have an example that uses ASPMail to do the emailing instead of trying to
use Outlook automation etc...

Our customers use this to do things like:
- Once a week send out a thousand emails to customers with each email having
PDF attachments
with the customers invoice details or other specific report(s) for the
customer.
etc...

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

PS: Giving away source code at the $99.95 price right now, just because we
don't like supporting
MDEs.
 
Back
Top