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 !

Oct 31 '06 #1

scripto

look up this command and add to your Outlook code.

.DisableOOMWarnings = True

Oct 31 '06 #2

contactvishwa

look up this command and add to your Outlook code.

.DisableOOMWarnings = True

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

May 30 '07 #3

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?

May 30 '07 #4

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

Jul 2 '07 #5

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.

Jul 2 '07 #6

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.

Jul 2 '07 #7