Hello,
When I run a macro from Excel to send an e-Mail, it displays a warning that I either must Allow or Deny. I want to Allow, without ever seeing this prompt.
I have attached an example!
Thanks for all of your help in advance.
Hello,
When I run a macro from Excel to send an e-Mail, it displays a warning that I either must Allow or Deny. I want to Allow, without ever seeing this prompt.
I have attached an example!
Thanks for all of your help in advance.
Hello EnigmaMatter,
Sorry, you can't do that. It is part of the built-in security for Outlook. It has been that way since Outlook 10.0.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Can't you create an instance of outlook, an object, and send from outlook without the message?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Hello Solus,
The security check is part of the application program. You won't bypass the message by creating a new instance because the instance class is the same as the application clalss.
Thanks! I'll just have it .Display then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks