Auto email a pdf report daily from ACCESS

[wsm_al]

Hi,
I am working on Access2007. I designed a report that I need to email every night automatically to my client. The report resides in the Access database. I currently use a macro to auto email this report for me but it still requires me to double click the macro to make it run. I actually want the report to be email at night without having me running the macro manually. Is there any way to make this happen?
Thanks a lot in advance,

[pbaldy]

Personally I would create a db that performs your task when it opened and then quits (a macro named autoexec will run when the db opens). Then I'd run that db from Windows Scheduled Tasks.

[wsm_al]

Thank you pbaldy,
I have thought of this solution, but there is two issues with it. The DB is frequently opened so the report will be sent every time I open the DB. The second issue is there is some issues with windows scheduled task so I can't use it in the corporate for some reasons I don't know about. I am wondering if there is another way to do it.
Thanks again,

[pbaldy]

Well, by "create a db" I meant I'd create a db separate from the production db. This task would be all it did, so it would only be sent once, when called from Scheduled Tasks.

In any case, if you can't use Scheduled Tasks, you can use the timer event of a form that remains open and have it trigger your macro at that appropriate time. That of course requires the db remain open, and if it's open on more than one PC, it could be sent more than once. That's why I prefer the other method. I also prefer to not have the timer event running all the time if I don't absolutely need it.

[wsm_al]

Thanks pbaldy for your quick reply! I did the scheduled task and it works fine now. This is a better option. However, I still get a security warning message from outlook saying " a program is trying to send an application on your behalf.... do you want to allow....) and I have to click on ALLOW. this is not solving the problem either because it still requires a manuall action to make the report to be sent out. Thoughts??

Thanks for your time,

[pbaldy]

That's an Outlook issue (and I thought you couldn't use Scheduled Tasks). I typically use CDO to email things out when I'm doing things like you are, as it gets around the warnings. Other options include a free utility called ClickYes and Outlook Redemption. Google should have more info on all 3.

[wsm_al]

Thanks again! I got your point.

[pbaldy]

Happy to help!