Click Yes

[msnow]

I have a nice little macro that emails about 100 reports out automatically. However, I just got a new laptop and now I get a warning, prior to each report that tells me that my computer is trying to send email, do I want to permit it. Does anyone know of a way around this? I have heard of a program called "Click Yes", does anyone know where I can get it?

 

[Dugantrain]

I've never done something like the task that you're describing so I don't know if this will work, but in the Macro's code, try starting the code off with:

DoCmd.SetWarnings False

to turn off the application's built-in Warnings. After the code executes which fires off your e-mails, turn the warnings back on:

DoCmd.SetWarnings True

 

[msnow]

Does that turn off Outlook warnings as well? This is an Outlook warning not a Access Warning.

Thanks for the info.

 

[dk]

Hi,

Using DoCmd.SetWarnings False will not prevent the Outlook dialog from appearing. To prevent this you can download and install something called Redemption see http://www.dimastr.com/redemption/ for details.

There are some code examples on this board and you can find these by searching for the word 'redemption'. Here's a good one:-

http://216.92.17.166/board2/viewtopic.php?t=13446&postdays=0&postorder=asc&start=10