View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://www.rondebruin.nl/mail/prevent.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"sh0t2bts" schrieb im Newsbeitrag
...
Hi All


I have an excel workbook that sends and e-mail once it has finished

running
a macro, I designed this workbook using Office2000 and for the last

18 month
or so a e-mail has been sent every time the macro finishes :o)

However the IT department has just rolled out Office 2003......

Now my excel workbook still works but Outlook blocks it from sending

the
e-mail, well I say it blocks it what it does is prompt me with an

alert box
advising that an application is trying to access the address book do

I want
to allow this ? I have the option to allow this for up to 10 minutes

but as
the macro runs at 6 in the morning this is no good to me.

does anyone know how to turn the security option off or know of some

VB code
that would allow my macro to by pass outlook security?


Many Thanks

Mark