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

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