OLE OUTLOOK Security

Fuism has asked for the wisdom of the Perl Monks concerning the following question:

Im having a problem trying to run the code by Foggy Bottoms in the thread Win32::OLE Outlook and E-mail security update. I am trying to send reports using Outlook because they have locked any access to our SMTP server. I get the securtiy pop-up trying to send mail using my automated Perl script. I cant seem to be able to send .xls using sendmail and cannot use most of the perl modules to send mail because they are not supported by Activestate. What is he referring to(LTG) with this line of code?

   $securityHandle = LTG::dialog::findSecurityWindow(); # wait for sec
[download]

Thank you for your wisdom... Fue

Edit g0n - linkified referenced thread

Comment on OLE OUTLOOK Security Download Code

Replies are listed 'Best First'.
Re: OLE OUTLOOK Security by GrandFather (Saint) on Aug 23, 2005 at 22:02 UTC
If SMTP is "locked" how is Outlook sending mail? In principle at least Mime::Lite or Net::SMTP should be able to send anything that Outlook can. Perl is Huffman encoded by design.	[reply]
Re^2: OLE OUTLOOK Security by inman (Curate) on Aug 24, 2005 at 09:29 UTC
Outlook is probably using MAPI to connect to Exchange Server. The OP could look at using MAPI directly rather than via Outlook.	[reply]
Re^2: OLE OUTLOOK Security by Fuism (Beadle) on Aug 23, 2005 at 22:23 UTC
Well Im using outlook on my local machine to send the email(using Activestate Perl), rather than going straight thru the SMTP server. My scripts using the SMTP server worked for about 2 weeks(about 3 months ago). I started using sendmail on unix to send .csv attachments instead of .xls(for some reason the .xls files were getting corrupted). My clients prefer .xls so now Im trying to send it with Outlook. They are trying to secure the whole network here at work. We will soon be using SSH and SFTP rather than telnet and FTP. I will have to make some more changes to my scripts :(	[reply]
Re^3: OLE OUTLOOK Security by GrandFather (Saint) on Aug 23, 2005 at 22:34 UTC
What I'm suggesting is that if Outlook can drive SMTP so that it can send mail, your code should be able to drive SMTP in the same way to be able to send mail. The Net::* modules should give access to the facilities you need to make that work. Perl is Huffman encoded by design.	[reply]
Re^4: OLE OUTLOOK Security by Fuism (Beadle) on Aug 23, 2005 at 22:39 UTC
Re^5: OLE OUTLOOK Security by Fuism (Beadle) on Aug 23, 2005 at 22:45 UTC
Some notes below your chosen depth have not been shown here