Workflow application for ABN AMRO

This 'workflow' application is primarily useful in environments (with one or several people performing the same role) where lots of automated reports need to be sent out daily/weekly/monthly.

The application is essentially a to-do list of things to be sent out, and other actions to be taken. It can be configured to:

• detect when files have been created (by scanning file locations with regular intervals)
• automatically (or only after manual action) send these files out to specified e-mail recipients
• automatically collect return receipts

The list shows to all users of the program, which actions already have been done and which are still open.

the main screen of the application. The large area is the main tak list (which is a lot larger in production environment and will contain mostly entries of type 'Create File').

Code specifics

The mail system used is Lotus Notes. As there seeems to not be much VB(A) code examples for communicating with Lotus Notes: feel free to delve into the code and see if there's anything interesting in there.

Some properties of the general code framework are mentioned on the 'Macro Cash Flow Hedging' page - the framework has been taken from there. Only the first point (security) does not apply here.

Copyright issues

The copyright on the Workflow application resides jointly with ABN AMRO Bank and myself, since I developed the application while working for ABN AMRO, but used lots of standard code which I had already written earlier.

There is very little ABN AMRO-specific code in this program, so if someone is really interested in using a tool like this, I could probably make one quite soon, which does not infringe on ABN AMRO copyrights.

The MDE file present in this archive works; the MDB file does not, because not all sources are present. (I currently cannot give out the full source code to the 'SQLBuilder' classes, because of issues mentioned on the SQLConvert page.) The MDB file is only useful for people who like getting acquainted with another programmer's code and techniques.