Wizard
09-30-2008, 02:32 PM
Running Outlook 2003 (so why I spent 1/2 hr looking in my Office 97 Tech Ref, I'll never know).
We have a situation where we are sending many reports via email, using an Excel macro. Sometimes, when the splitter/mailer macro is running and a new email comes in, the new mail desktop alert pops up - and crashes the Excel macro.
This happens most often when a cluster of emails (usually 'out of office' emails) come in all at once
I know how to turn the notifications off manually... Is there a way to turn the notifications off (and, later, back on) via VBA?
Thx
We have a situation where we are sending many reports via email, using an Excel macro. Sometimes, when the splitter/mailer macro is running and a new email comes in, the new mail desktop alert pops up - and crashes the Excel macro.
This happens most often when a cluster of emails (usually 'out of office' emails) come in all at once
I know how to turn the notifications off manually... Is there a way to turn the notifications off (and, later, back on) via VBA?
Thx