Thread: Outlook Again
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gti_jobert[_122_] gti_jobert[_122_] is offline
external usenet poster
 
Posts: 1
Default Outlook Again


Hi all,

I have a function that opens Outlook but then loops continously until
the Sent Items Folder count has incremented by 1 (confirming the email
has been sent) but IF the user decides not to send the email, and
closes excel then the do loop will carry on and on (like a duracell
battery) and basically crashes excel.

within my do loop I need something that can determine.check whether or
not Outlook has been exited or something on those lines?!

Any help appreciated! Cheers guys!


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=545784