Well, perhaps it sheds some light on what I'm trying to do.
What is desired is a nice and easy way for the macro to drop an arbitrary outgoing mail message into the drop box of an SMTP mail server.
(And isn't really needed since user just runs the mach from a quick launch toolbar button). Meanwhile, using a browser, or ActiveX control, Form controls, etc to trigger sending the mail is just the front end. However, the CDO functionality isn't available on OSX. Using CDOSYS, the mail message to be sent was simply dropped onto the dedicated mail server directly - thus ignoring the local user and email applications altogether. and also allow them to monitor it for unnatural traffic. Our IT guys set up a dedicated mail relay server that we could use for sending the macro generated mail messages.
#EXCEL FOR MAC VBA WINDOWS#
Ĭonsequently, the CDOSYS solution worked well from Windows Excel. And there are dozens of such automation tools already (a mailto: link in a browser for instance).īut if normally no user scripts are allowed to access a mail client then, if one does, it would be more easily spotted (or some such theory). it's certainly possible to do such evil, nefarious, things anyway. would have a "backdoor" hole for internal spying of that user's email account (private messages, etc). which was given access to the user's email application (even if using a dedicated email account). However, it's also for internal security reasons.įor example, a VBA script from a co-worker / inside the firewall / on trusted network machine. The obvious case is viruses - eg, Outlook is famous for being exploited. This is first and foremost due to security concerns. In other words, the VBA macro cannot directly utilize Outlook, Apple Mail, Thunderbird, or any other mail application client the user might use as the primary mail application.
0 kommentar(er)
