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

Closes Excel, do you mean Outlook? If so, just check if there is still an
instance of Outlook running, using GetObject.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"gti_jobert" wrote
in message ...

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