View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] jamesp@premiercs.co.uk[_2_] is offline
external usenet poster
 
Posts: 17
Default Excel VBA with outlook

I am using XL 2003 to send out emails to about 50 clients. However when I do
this Outlook 2003 comes up with a dialog stating that I am automatically
sending out an email and I have to client on the Yes button 50 times.

I know this is a very good feature but for the purposes of my macro can I
turn it off and then back on after the macro has finished

Many thanks

James