Emailing Reports with Criteria

[Rone]

I have multiple reports I need to automatically send in an email to managers.
All these reports are based off of queries that have criteria, which require
the user to input before the report will run.

I want to email these reports with some "standard" criteria that doesn't
require user input at run time, but I still want the reports to also provide
the user with the ability to add the criteria if the user clicks on the
report to view it manually. Right now when I email the reports the reports
pop up the criteria input box and require a manual entry before the report
runs, but if I want to run these reports automatically in the middle of the
night no one will be here to supply the criteria. I want to bypass this
popup box and through VBA pass the critera so the report still will send the
email automatically. Also, I would like to use the same reports and queries
I already have so I don't have to create new ones.

Anyone got any ideas how to accomplish this?

Thanks in advance.

 

[Jeff C]

What kind of criteria? Have you considered looping through a table of
variables? To use the sendobject function you will need a third party
software like "click yes" for emails to be automatically emailed.

 

[Cyber-guy via AccessMonster.com]

What kind of criteria? Have you considered looping through a table of
variables? To use the sendobject function you will need a third party
software like "click yes" for emails to be automatically emailed.

I have multiple reports I need to automatically send in an email to managers.
All these reports are based off of queries that have criteria, which require

[quoted text clipped - 14 lines]

Thanks in advance.

I use Ostrosoft.com's smtp mail component (FREE!) to automatically send
reports as PDF attachments (I use Leban's PDFtoReport for that part) to
various recipients via email - the subject & message body can both be changed
via VBA as well as attachments, recipients, CC, BCC - very flexible - the
whole process runs in the background with a single click - in your case you'd
likely be scheduling the run instead.

Hope this helps'
Cyber-guy