G
Guest
I write a suite of integrated VB and VBA applications in Access and Excel. At
night there is a big script that runs and mails Excel sheets using Send
to.... to several people, both inside and outside the company. Using Outlook
is very easy, doesn't _require_ me to save the file out first, and it also
leaves a copy of the message in the Sent Items which make tracking and
debugging very easy.
Unfortunately this process also pops up the Outlook security dialog, which
often get hidden in window clutter, or not seen at all before it times out.
There's about a 1/2 dozen of these that go out, spaced out just long enough
to lose the operator's attention. As a result many of our nightly runs end in
failure as the operator never clicks OK and the program either stops there
permanently waiting for the click, or alternately fails out with an error and
the other reports don't get mailed.
Any suggestions here? Is there a (safe) way to turn off this security
feature? Alternately, is there something else entirely I should consider?
Maury
night there is a big script that runs and mails Excel sheets using Send
to.... to several people, both inside and outside the company. Using Outlook
is very easy, doesn't _require_ me to save the file out first, and it also
leaves a copy of the message in the Sent Items which make tracking and
debugging very easy.
Unfortunately this process also pops up the Outlook security dialog, which
often get hidden in window clutter, or not seen at all before it times out.
There's about a 1/2 dozen of these that go out, spaced out just long enough
to lose the operator's attention. As a result many of our nightly runs end in
failure as the operator never clicks OK and the program either stops there
permanently waiting for the click, or alternately fails out with an error and
the other reports don't get mailed.
Any suggestions here? Is there a (safe) way to turn off this security
feature? Alternately, is there something else entirely I should consider?
Maury