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,
