Emailing Snapshot format

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
 
R

Rick Brandt

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?

In the newer versions, yes. In Access 97 use "Snapshot Format" (including the
quotes).
 
A

AlCamp

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
 
M

Mark Andrews

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.
 

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

Similar Threads

Emailing Snapshot 1
SendObject Report A2007 6
PDF to SendObject 3
convert report to pdf and then email 5
Access - Create PDF 1
Access Create PDF 1
Snapshot of report 4
sendobject from mde 4

Top