ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Outlook Warning Messages (https://www.excelbanter.com/excel-programming/363079-outlook-warning-messages.html)

AD108

Outlook Warning Messages
 
I just finished (hopefully) making a small application. It sends emails to
every customer in the state or country the user specifies. It works fine
except that I get the following warning message for each email that the code
pulls, which the user then has to respond to each time before they can
proceed.

"Warning, a program is trying to access email addresses you have stored in
Outlook"....etc.

Is there a way to turn this off. I tried using "application.displayalerts =
false" but it didn't work. Maybe I put the statement in the wrong area of
the code.

Thanks in advance.



Corey

Outlook Warning Messages
 
I think you may need to lower the SECURITY level to disable this Warning in
Outlook.
Outlook Expres under security tab has a tick box to 'Warn if another
application is trying to send mail'.
I would say MSOutlook would be similar but, cause i do not use it am not
exactly sure what setting it will be, but am sure it will be under security
somewhere.
Corey....



NickHK

Outlook Warning Messages
 
Application.DisplayAlerts=False will not work, as this message is generated
by the Outlook application, not Excel.
One option is Redemption: http://www.dimastr.com/redemption/

NickHK

"AD108" wrote in message
...
I just finished (hopefully) making a small application. It sends emails

to
every customer in the state or country the user specifies. It works fine
except that I get the following warning message for each email that the

code
pulls, which the user then has to respond to each time before they can
proceed.

"Warning, a program is trying to access email addresses you have stored in
Outlook"....etc.

Is there a way to turn this off. I tried using "application.displayalerts

=
false" but it didn't work. Maybe I put the statement in the wrong area of
the code.

Thanks in advance.





AD108

Outlook Warning Messages
 
Thanks for the reply. I looked for ages and coudn't find the setting.
Maybe someone else out there knows?


"Corey" wrote in message
...
I think you may need to lower the SECURITY level to disable this Warning

in
Outlook.
Outlook Expres under security tab has a tick box to 'Warn if another
application is trying to send mail'.
I would say MSOutlook would be similar but, cause i do not use it am not
exactly sure what setting it will be, but am sure it will be under

security
somewhere.
Corey....





AD108

Outlook Warning Messages
 
Thanks for the lead, I'll look into it.

"NickHK" wrote in message
...
Application.DisplayAlerts=False will not work, as this message is

generated
by the Outlook application, not Excel.
One option is Redemption: http://www.dimastr.com/redemption/

NickHK

"AD108" wrote in message
...
I just finished (hopefully) making a small application. It sends emails

to
every customer in the state or country the user specifies. It works

fine
except that I get the following warning message for each email that the

code
pulls, which the user then has to respond to each time before they can
proceed.

"Warning, a program is trying to access email addresses you have stored

in
Outlook"....etc.

Is there a way to turn this off. I tried using

"application.displayalerts
=
false" but it didn't work. Maybe I put the statement in the wrong area

of
the code.

Thanks in advance.







Ron de Bruin

Outlook Warning Messages
 
See also
http://www.rondebruin.nl/mail/prevent.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



"AD108" wrote in message ...
I just finished (hopefully) making a small application. It sends emails to
every customer in the state or country the user specifies. It works fine
except that I get the following warning message for each email that the code
pulls, which the user then has to respond to each time before they can
proceed.

"Warning, a program is trying to access email addresses you have stored in
Outlook"....etc.

Is there a way to turn this off. I tried using "application.displayalerts =
false" but it didn't work. Maybe I put the statement in the wrong area of
the code.

Thanks in advance.






All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com