Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA | Excel Discussion (Misc queries) | |||
how to catch the second or more cell with vlookup | Excel Worksheet Functions | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Responding to Outlook Errors when useing Sendmail!! | Excel Programming | |||
Catch-22 with Error 59 | Excel Programming |