Security warning in Outlook when running Access Macro

[Chris]

I run a macro in Access that sends approximately 50 emails. I was using
lotus notes and had no problems at all. Now that I have installed Outlook
2003 I get the warning stating that someone is trying to send an email
message and it could be a virus do you want to allow this. Is there any way
that I can bypass this. It takes 15 minutes as I have to sit and hit yes for
every email that I want to send

Any solutions????

 

[Steve Schapel]

Chris,

What you are referring to is a security feature of Outlook, and not
really related to Access. As far as I know, this can't be turned off.
I know some people have had success with using a third-party utility
called ClickYes, available from
http://www.contextmagic.com/express-clickyes/

 

[Chris]

thank you very much. Would it be possible to convert the macro to vb and
bypass the outlook message that way. If not then I will look into
ClickYes......Thank you again

 

[Steve Schapel]

Chris,

No, it hasn't got anything to do with it being a macro.