Is the following possible....

[Simon Harvey]

Hi everyone,

I'm wondering if there is any way i can do the following. I have some
reports in access that I would like to be able to email to people
automatically. What needs to happen is that the application goes through the
rows in a given table, generating the reports and emailing them on the fly.
The idea being that we could start this job off and leave it to run over
night.

I know how to send an email using vba, but I'm wondering if we could send
the report as a pdf. As such I need a component that can create a pdf and
that can be called from VBA.

Any help would be greatfully received

Thanks all

Simon

 

[Cheryl Fischer]

I know how to send an email using vba, but I'm wondering if we could send

the report as a pdf. As such I need a component that can create a pdf and
that can be called from VBA.

You will need 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 programmaticaly turn the program on before generating
the email process and then turn it off when the process has completed.

Last, you may want to review other options found at Access MVP Tony Toews'
website: http://www.granite.ab.ca/access/email.htm

hth,

 

[Simon Harvey]

Great answer Cheryl,

Sincerest thanks

Simon

 

[Cheryl Fischer]

You're welcome - good luck with your project.