Automate Reports using PDF format

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Hello,

Is there any way to add the PDF format to the list of
formats to email out? The options now are snapshot,
excel,rtf,html,wordpad.

Thanks,
Lisa Barsalona
 
If you are asking whether a PDF format can be added as an option for the
SendObject method, no that is not possible, AFAIK.

To automate creating a PDF file from an Access Report and building an email
to which the PDF file is attached, you first would need to use Automation
with Outlook. Here are some links with sample code that you can look at:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm


You would need then a PDF driver for each user of the application; I use and
recommend PDF995. http://www.pdf995.com . You may need their PDFEdit
product (or some other add-in) to take care of the programmatic document
naming that you'll require for an automated process. I use the ACG Soft PDF
and Mail library for this purpose in my apps:
http://ourworld.compuserve.com/homepages/attac-cg/

If you have done any emailing from an Access app, then you should be
familiar with the Outlook Security Prompt that requires that a user click a
button each time Access attempts to send an email. If you want to automate
your process fully, I recommend the free ClickYes utility to do that job:
http://www.express-soft.com/mailmate/clickyes.html; using code provided at
their website, you can programmatically turn the program on before
generating the email process and then turn it off when the process has
completed.

hth,
 
Or you could get yourself a good PDF printer driver, get some code to make
PDF files from Access
(we sell source code for $99.95 that does this) and buy a $40 third party
email component
and you don't need to worry about having problems with Outlook.

We have sample code that loops through a recordset of customers and reports
they want, creates the reports
to PDF files and then emails each customer (where each email has an attached
PDF file).

Email me details of what you want to do and I can help you with how to write
the code if needed.

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