how to catch errors from outlook
 

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

how to catch errors from outlook
 

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" wrote in message
ups.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