Sending mail from Excel in VBA, how to avoid security questions?

[Maury Markowitz]

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

 

[John Blessing]

Without a re-coding, I suggest you try:

http://www.contextmagic.com/express-clickyes/

May not be safe to leave it running all the time, (although I believe
practising "safe internet" is a better preventative), or you can open it at
the start of your code and then close it down when you are finished.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

 

[Maury Markowitz]

Without a re-coding, I suggest you try:

http://www.contextmagic.com/express-clickyes/

Thanks!

Maury