how to catch errors from outlook

[helpwithXL]

hi all,
I'm calling outlook objects (items eg mails etc) in my excel sheet. all
code is written in excel macros, how do i catch the errors generating
from outlook like when outlook is busy and i cant get access to inbox.

TIA
amit

[arunkhemlai]

Not sure, but have you tried with "On Error ..." yet?

arunkhemlai

"helpwithXL" wrote:

> hi all,
> I'm calling outlook objects (items eg mails etc) in my excel sheet. all
> code is written in excel macros, how do i catch the errors generating
> from outlook like when outlook is busy and i cant get access to inbox.
>
> TIA
> amit
>
>

[Bob Phillips]

Not exactly sure what you are doing in specifics, but normally try something
like

On Error Resume Next
Set myMail = olApp.whateverobject etc.
On Error Goto 0
If Not myMail is Nothing Then
'all is ok
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"helpwithXL" <s2016451@student.rmit.edu.au> wrote in message
news:1113486535.125510.42990@o13g2000cwo.googlegroups.com...
> hi all,
> I'm calling outlook objects (items eg mails etc) in my excel sheet. all
> code is written in excel macros, how do i catch the errors generating
> from outlook like when outlook is busy and i cant get access to inbox.
>
> TIA
> amit
>