Outputting reports as PDF files

[Leslie Isaacs]

Hello All

I want to use the SendObject macro command to email reports to people. This
works great with the reports sent as snapshot files, but obviously PDFs
would be more universally acceptable to the recipients. But PDF is not an
available format for the SendObject macro command. I have installed CutePDF
writer and so can 'print' PDF files, but I really want to be able to
generate and send the reports automatically - as I now can with using the
SendObject macro command and Snapshot formats.

Can this be done?

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Steve Schapel]

Leslie,

In design view of your report, go to the File|Page Setup menu, Page tab,
select 'Use Specific Printer', and nominate your CutePDF driver. Then
use an OpenReport action in your macro to save the report to a PDF file.
Then you will need to manually attach these to your emails. You will
not be able to use SendObject to attach the PDFs. There are ways of
doing this, using Outlook automation for example. There is some
information about this here...
http://www.granite.ab.ca/access/email/reportsasattachments.htm

 

[Chris Reveille]

I use Access 2000 and Outlook. I have a good little
database example that will browse the Outlook contacts for
the Sender(s), subject, body and file information from a
form(that let's you browse for up to five attachments) and
put them in an email. All the user has to do is type in
the file attachment name or click and browze for the file
in the form. The code used is from previous posts. If you
want it I will email it to you.


Chris

 

[Jack Isaacs]

Steve

Thanks for the info - I will have a look at the link you suggested.

Les

 

[Mark Andrews]

I would recommend using a third party email component over going to extremes
and automating outlook.

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