View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Remove - "A program is trying to access e-mail addresses you..."

It,s a security warning which as far as I am aware, cannot be turned off
programmatically.
See Ron de Bruins site for tips on mailing via outlook.
http://www.rondebruin.nl/sendmail.htm
--
JB


"scott56hannah" wrote:

I have written an Excel VBA script that will create and update Outlook Task
information based on other details in an Excel spreadsheet.

I need to find a way to remove the following security prompt that is
returned when the script is run...

"A program is trying to access e-mail addresses you have stored in Outlook.
Do you want to allow this ?"

It thens give the user the option of allowing for a number of minutes....if
selected the script executes correctly...

Is there a way to disable this warning ? or change a registry setting from
within the script so that it does not prompt during the execution.

Any help appreciated.