Outlook Again

[gti_jobert]

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!

[Bob Phillips]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>