Disable Outlook 2010 e-mail security prompt

[VARGEESH]

Hi,


I used to send emails from excel using outlook.


When I send emails it displays a security prompt to send or not send the message. It is okay when I send up to five messages. But at the time of 100 emails for each email I need to confirm the security prompt.


It will be helpful if I disable the security prompt or use the sendkeys yo automate the confirmation.


I made a google search and found the following code and I do not know how do I use in my code:

[pre]

OlSecurityManager.DisableOOMWarnings = True
On Error Goto Finally
' ... any action with protected objects ...
Finally:
OlSecurityManager.DisableOOMWarnings = False

[/pre]

or if I have to use senkeys please mention how and where I have to put it in my code.


Note: When all the emails sent it should display a message box".


Here is the code:

http://www.2shared.com/document/hkojcphW/emailcode.html


Please advise me.


Regards,

Vargeesh M

 

[Debraj]

Hi Vargeesh,


Are you talking about This Message


If Yes.. Then why you are asking help from Excel and why not from Outlook > Option > Setting ..


Regards,

Deb

 

[VARGEESH]

Hi Ded,


Thanks for your answer.


Since I am not much aware of it I asked the question.


If there is solution please let me know


Thanks,

Vargeesh

 

[Debraj]

Sorry Vargeesh,

I don't have enough knowledge in Outlook Object Model... But I guess..

* if you set Outlook's "Auto Confirm Outlook Security message" it will stop asking..

Or

try by comment the below line..

'                .SentOnBehalfOfName = cell.Offset(0, -1).Value

so that it will not send "OnBehalf of someone" and avoid the warning message..


Please let us know if it help you in any case..


BTW.. did you find any way to display all files in a folder.. or need some help..


Regards,

Deb

 

[VARGEESH]

Yes Deb,


I found just before.. Here is the code.


http://www.2shared.com/document/KDM-RKuk/Fiepath.html


Thanks for you..