A program is trying to automatically send email on your behalf

[mattc]

Hi,
Writing a Macro in Excel and wanting to send emails automatically without this pop up box "A program is trying to automatically send email on your behalf".
Is there some script I can use to avoid this pop up ?

I'm just a beginner.... please help.

Thanks !

[scripto]

look up this command and add to your Outlook code.

.DisableOOMWarn ings = True

[contactvishwa]

look up this command and add to your Outlook code.

.DisableOOMWarn ings = True

this code is not working for me pls help on the same issue

[Killer42]

I think to get around that, the user would have to turn off (or at least reduce) the macro security options in Excel. After all, what would be the point of having them at all, if the macro can just turn them off?

[QMSAND]

Hi,
Writing a Macro in Excel and wanting to send emails automatically without this pop up box "A program is trying to automatically send email on your behalf".
Is there some script I can use to avoid this pop up ?

I'm just a beginner.... please help.

Thanks !

Mattc

did you ever find out how to do this? I'm in the same boat you were

[danp129]

Well it should be a setting in outlook / outlook express, whichever is your default MAPI client so look there. I've seen a program that automatically closes the messagebox for you, just google around for that prompt and you'll eventually find something. Personally, I'd just use CDOSYS.

[Killer42]

Yes, I just pasted "A program is trying to automatically send email on your behalf" into Google, and found a lot of references, including ones with source code. I didn't go through them in detail, but there must be something there you can use.