Mago.net Magic Documents: Microsoft Office Integration

Anyone using the solutions based on Magic Documents only need to know how to use a calculation worksheet or insert a text document to be able to carry out complex management transactions.

All the phases of the procedure are guided and make using the software truly simple and intuitive.
 
Magic Documents can be used to create a practically infinite series of templates that can be customised however you like. Contact forms, offers, price lists, letters, statistics: these are just some of the possible documents that can be created, customised, shared.
 
All of this without the need for costly operations at the programming level, thanks to the application of the Smart Documents technology in Office.

With Magic Documents the integration of Mago.net and Office achieves two significant results:

• It enables an Office user to populate an Excel or Word document with data extracted in real time from the company database to simply and effectively create analyses, reports, graphs etc…
• It also enables operators without expertise in using the management programme to insert or extract data and documents into/from it continuing to use a familiar interface like Word and Excel

People using the solutions created with Magic Documents can work on data managed by Mago.net while continuing to use the powerful functions of the Word and Excel interface (tables, fonts, colours, images etc…) to create pleasant, easy-to-consult documents, which can also provide a direct vision of the company data without having to do any intermediate exports.

The documents created with Magic Documents can be managed as templates to be reused again and again, and to update the data contained in them with a simple click.

• For example, a sales manager can update a sales analyses electronic worksheet, already formatted and including layout, with the most recent data available and immediately print it or share it with associates.
• An Administrative manager can do the same thing with an accounts analysis to send via email to the Auditors to be discussed in the Board of Directors meeting.
• A salesperson can "download" the offer inserted into Mago.net in compliance with the company sales policies into a Word document with layout prepared and add other information, details etc… to it.

It is possible to collect all the document templates created with Magic Documents in a shared "container", for example at the company or department level.

Magic Documents can be used to organise the solutions in the Resource Repository of Mago.net; people who are authorised to use it can access it by navigating with the Menu Manager, using both Mago.net and directly from inside Office.

Therefore, the latest and most up-to-date versions of documents like offers, standard-letters, statistics are available, and will therefore have a standardised and institutionalised appearance, the contents of which can easily be defined and updated to suit the company needs.

On balance, the solutions developed with Magic Documents provide real savings on the total cost of the IT system management, with the following advantages:

• Fewer risks of error. It is possible to eliminate the “copy and glue” operations that are often sources of error, having to work at the same time on different applications in order to retrieve data to be inserted in the document.
• Lower staff training costs. It is no longer necessary for everybody to know how to use the management programme thoroughly; it is possible that some personnel in the company only need to use the Word and Excel templates.
  Simplification to find information. Thanks to Magic Documents it is also possible to search company archives and retrieve the information in the various sections of the document currently being worked on, all without leaving Word or Excel, in a fraction of the time normally needed to retrieve the data found in separate applications.
• Customise at a lower cost. Developing a solution using the Office tools is quicker and less expensive than with normal programming tools. Often the end user already has the know-how needed and they can pass from idea to creation without a long and expensive software development project.

To be able to work on the management system and the company database using the solutions created with Magic Documents, it is necessary for the user to be recognised by the system with login and password.
 
Access is granted according to the same criteria attributed for access to Mago.net; if a user has the right to use a function, that setting will have value both when they access through Mago.net and through the Magic Documents solutions.
 
Furthermore, user profiling enables the company to set levels of access to data differentiated according to the company roles so that, for example, an administrative manager can access accounts data, analyse it, extract it, while a sales department worker can load or extract data relative to contacts.
 
Note that in both cases, the use of simplified or in any case customised interfaces can be of great assistance in their jobs, without sacrificing anything at all in terms of protection and confidentiality of company data.