Skip to main content

[archive] COM Wrapper for AcuCobol

  • March 9, 2005
  • 21 replies
  • 0 views

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob

21 replies

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Take a look at Outlook Redemption
It's a COM library that works around Outlook Security restrictions.

Another COM library that looks even simpler to use is here: http://www.add-in-express.com/outlook-security/

Your Lookout pun did not go unnoticed. ;-) What's really funny is that Lookout is an actual product for Outlook that indexes and searches outlook messages. It's free and works great, I use it whenever I need to find those hard to remember emails. Check it out here: http://www.lookoutsoft.com/Lookout/

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Thanks, Dan. Has anyone tried any of these? They look simple and straight forward...

BTW, Happy Birthday to Gisle! - since I know he'll read.

Rob

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Thanks, Dan. Has anyone tried any of these? They look simple and straight forward...

BTW, Happy Birthday to Gisle! - since I know he'll read.

Rob

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Thanks Robstan :-) But hush, it is a secret :-D

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Originally posted by Robstan
I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.
...
I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob


I am not sure what you mean by saying supported by ACUCOBOL-GT, ACUCOBOL-GT will not suit as a COM wrapper not with 6.2 or later if that was what you meant. But we have been able to USE a COM AddIn (which is what this really is about) since we started supporting COM.

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Gisle,

I think I like Dan's solution better, so I'll probably pursue that avenue anyways...

But to clarify what I mentioned before about the COM... Outlook has an ability to trust a list of "COM add-ins". I made an inquiry to AcuCorp support a while back asking what it would take for AcuCobol to be a trusted COM add-in and they said that presently is wasn't available, but should be in 6.2 (this was a LONG time ago). Perhaps I (or someone) is confusing the issue, but I like the solution of using an Active-X control better anyway.

Regards,
Rob

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Gisle,

I think I like Dan's solution better, so I'll probably pursue that avenue anyways...

But to clarify what I mentioned before about the COM... Outlook has an ability to trust a list of "COM add-ins". I made an inquiry to AcuCorp support a while back asking what it would take for AcuCobol to be a trusted COM add-in and they said that presently is wasn't available, but should be in 6.2 (this was a LONG time ago). Perhaps I (or someone) is confusing the issue, but I like the solution of using an Active-X control better anyway.

Regards,
Rob

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Rob, to create a COM add-in for MS Office you would have to create a COM wrapper around the acucobol automation server in VB or C that implements certain interfaces that the MS Office add-in manager would look for. There are several MSDN articles on this. It is certainly not a trivial matter. Also, this does not sound like a viable option considering the runtime is using office automation and not the other way around and so I don't think you would be able to gain proper trust to Outlook security this way. I could be wrong, just a quick observation on my part.

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
You are correct Dan.

Now guys, here is my stand on this: Implementing COM-Addins support in the runtime is not going to happen. If we were to do anything, it could be an opportunity too make a COM-Addin that the runtime then could use as a gateway, but that is another story, and frankly, I think we can make better use of our resources than doing that. Particularly when there are already other 3rd party vendors that have a solution.

But, of course, as James Bond would put it; "Never say never again" :-)

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Using a solution like Outlook Security Manager from add-in-express.com or Redemption does however expose a security risk to end users in that other "rogue" software could look for these installed components and try to use them in an abusive way. Redemption seems to have a good solution for this here: http://www.dimastr.com/redemption/security.htm
I don't know how the Outlook Security Manager from add-in-express.com handles this.

The idea of an acucobol secure MS Oulook "gateway" add-in might perhaps be a project one of Acucorps' partners could consider. Of course there would have to be a good business reason(viable market) to invest developing this. For instance, Landmark Software(http://mapiland.land-mark.com.au/) has an email dll library(MapiLand) that they market to aucobol developers. I wonder how they recommend dealing with Outlook Security issue?

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Using a solution like Outlook Security Manager from add-in-express.com or Redemption does however expose a security risk to end users in that other "rogue" software could look for these installed components and try to use them in an abusive way. Redemption seems to have a good solution for this here: http://www.dimastr.com/redemption/security.htm
I don't know how the Outlook Security Manager from add-in-express.com handles this.

The idea of an acucobol secure MS Oulook "gateway" add-in might perhaps be a project one of Acucorps' partners could consider. Of course there would have to be a good business reason(viable market) to invest developing this. For instance, Landmark Software(http://mapiland.land-mark.com.au/) has an email dll library(MapiLand) that they market to aucobol developers. I wonder how they recommend dealing with Outlook Security issue?

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Well, here's bringing back an issue from a little while back... For anyone interested, we have been able to implement an ActiveX Control into our application that avoids the Outlook messages that appear when you use the Outlook Object Model to manage contacts, tasks, e-mails, etc.

With Gisle's expertise, we were able to implement the Outlook Security Manager control (http://www.add-in-express.com/outlook-security/). This was very easy to implement, just a few lines of code. Essentially how this works is that immediately before you make the calls to Outlook, you disable the warning messages and when you're done you enable them back.

I'm not exactly sure why something like this can exist because it seems like virus writers and hackers would just use it in their viruses, but...

This looks like it is going to work for our purposes and thought I'd mention it in case someone is looking to do this. Unfortunately, this control doesn't have a trial version, but instead offers a 30-day money back guarantee. If anyone is interested in a sample program, just let me know. Of course, it won't work without the control. :-)

Rob

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
To all of you that consider Rob's code here, please note the use of the new reserved word AS and the way it is used to provide the native handle of the object.

Effectively, this means you need 6.2.0 or later of ACUCOBOL-GT to use this.

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
But could somebody post a demo program that contain everything in it!

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
But could somebody post a demo program that contain everything in it!

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
I wouldn't mind posting the code, but I didn't think it was very useful without the control. You have to buy the control because it doesn't have a trial license or anything.

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
After reading these posts I purchased the Outlook Security Manager from Add-In Express. I would really appreciate a copy of source code that utilizes Outlook Security Manager.

Any clues would be greatly appreciated!

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Just realized the above posts are over 3 years old, so maybe there is a better solution for avoiding the Outlook security pop-ups other than using the OSM product. Read the posts about Redemption as well. Just a little confused on the best most straight forward solution.

We are doing basic emails of invoices from a batch style program. We are attaching a pdf file containing the invoice.

Any ideas or advice?

Thank you!

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Just realized the above posts are over 3 years old, so maybe there is a better solution for avoiding the Outlook security pop-ups other than using the OSM product. Read the posts about Redemption as well. Just a little confused on the best most straight forward solution.

We are doing basic emails of invoices from a batch style program. We are attaching a pdf file containing the invoice.

Any ideas or advice?

Thank you!

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Here's a sample program for the Outlook Security Manager.

Rob


    [FONT=&quot] IDENTIFICATION               DIVISION.
       PROGRAM-ID.                  TEMPLATE.
       ENVIRONMENT                  DIVISION.
       CONFIGURATION                SECTION.
       SPECIAL-NAMES.
       COPY "MSOUTLOOK.DEF".
       COPY "OSMC.DEF".
            .
       WORKING-STORAGE SECTION.
       77  CNTL-FONT                USAGE HANDLE OF FONT SMALL-FONT.
       77  KEY-STATUS               IS SPECIAL-NAMES
           CRT STATUS               PIC 9(4) VALUE 0.
           88  EXIT-PRESSED         VALUE 27.

       01 HApplication              HANDLE OF APPLICATION.
       01 HMailItem                 HANDLE OF MAILITEM.
       01 HRecipients               HANDLE OF RECIPIENTS.
       01 IOutlook                  PIC X(4) COMP-N.

       78 VT-DISPATCH               VALUE 9.

       SCREEN      SECTION.
       01  TEMPLATE-SCREEN.
           03      HOutlookSM       OutlookSecurityManager
                   LINE             1
                   COL              1
                   LINES            1
                   SIZE             1
                   VISIBLE          0.

       PROCEDURE DIVISION.
       MAIN-LOGIC.

           DISPLAY STANDARD         GRAPHICAL WINDOW
                   TITLE            "Sending mail"
                   CONTROL          FONT CNTL-FONT
                   SIZE             80
                   LINES            15
                   BACKGROUND-LOW.

           DISPLAY TEMPLATE-SCREEN.
           CREATE  Application      HANDLE IN HApplication.
           INQUIRE HApplication     @Application IN IOutlook.
           MODIFY  HOutlookSM       ConnectTo(IOutlook AS VT-DISPATCH).
           MODIFY  HOutlookSM       DisableOOMWarnings = 1.
           MODIFY  HApplication     CreateItem(0) GIVING HMailItem.
           INQUIRE HMailItem        Recipients IN HRecipients.
           MODIFY  HRecipients      @Add("[/FONT][EMAIL="jdoe@company.com"][FONT=&quot]jdoe@company.com[/FONT][/EMAIL][FONT=&quot]").
           MODIFY  HMailItem        Subject = "testing".
           MODIFY  HMailItem        Body = "testing".
           MODIFY  HMailItem        @Send().
           MODIFY  HOutlookSM       DisableOOMWarnings = 0.
           DESTROY HRecipients.
           DESTROY HMailItem.
           DESTROY HApplication.
           DESTROY TEMPLATE-SCREEN.
           STOP    RUN.[/FONT]
 

[Migrated content. Thread originally posted on 08 March 2005]

I am wondering if anyone has written a COM wrapper for AcuCobol that will allow users to setup as a "trusted" source for Outlook.

We have a lot of Outlook capabilities built into our software, but with the newer security contraints in LookOut (I mean Outlook), a message asks the user for access to Outlook each time. Many of our customers would like to have our software as "trusted" through Outlook.

Anyone done this? I recall that AcuCobol didn't support this until 6.2, but from what I understand it should work in 6.2 ...

Rob
Hi Rob -

Thank you for posting the OSM code - I truely appreciate your quick posting!

Thanks again!
Sheri