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.

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....

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.

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....

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.

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.