micosoft office 2000 · 2002 (XP) · 2003 · 2007 integration

DMW integrates the Access, Excel, Word and Outlook programs in Microsoft Office to make information flow with the minimum of hassle for the user.

We automate the sometimes complex operations that otherwise require boring, time-consuming and repetitive manual tasks, frequently prone to human error.

A main aim of DMW is to make the information a client holds readily available from a single source to anyone in their business who needs to use it. Thus efficiency gains are achieved in data collection, maintenance and storage, and in information distribution and reporting.

example of office integration

DMW's client, a multi-national, billed their clients on the basis of time spent on projects. Our client's main system converted timesheet information into invoices.

Unfortunately, many time sheets were not up-to-date and many more remained unsubmitted until a purge, usually towards the end of a project, hopefully filled in the gaps. Thus billing was far from consistent, and was sometimes back loaded. This lead to complaints about unexpectedly big invoices at the end of projects.

The main system could not identify timesheets that were incomplete or missing. DMW was engaged to provide an automated process for chasing timesheets.

Our Microsoft Access database linked with the main system and our algorithms determined which timesheets were incomplete or missing. Details of these were e-mailed via Microsoft Outlook to the offenders, prompting them brings things up-t0-date. Heads of departments were notified of anyone failing to respond.