By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,986 Members | 1,537 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,986 IT Pros & Developers. It's quick & easy.

A program is trying to automatically send email on your behalf

P: 1
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
Share this Question
Share on Google+
6 Replies


scripto
100+
P: 143
look up this command and add to your Outlook code.

.DisableOOMWarnings = True
Oct 31 '06 #2

P: 2
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

Expert 5K+
P: 8,434
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

P: 1
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
Expert 100+
P: 321
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

Expert 5K+
P: 8,434
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

Post your reply

Sign in to post your reply or Sign up for a free account.