Introduction

This module provides an OpenOffice.org/LibreOffice extension plus a small interface to the Aeroo Report module on the OpenERP side to allow mail merge directly from the Writer application. Mail merge is performed on records stored in the saved selection in Odoo. The result is a single document in editable ODF, appearing in a new office window.

The ability to perform mail merge on the fly reliefs the administrator from having to create a Report XML record in the OpenERP database and upload the template after every change.

After installation of this module, you can download the extension file from your Odoo database under

Settings -> Customization -> Aeroo Reports -> Download Office Extension

Usage

In the web client, save a custom filter. When doing a mail merge, choose one of those filters and your document will be filled with the records in the filter's selection.

Figuring out the correct fields to use can be tricky, use the web client's debug mode to find out a field's name. Further, consult the provided document template (this is a mail merge intended to work on partners) for some general usage hints.

Requirements

On the client side, you need to install the extension via Tools -> Extension Manager -> Add. After installation, restart Writer in order to see the newly created menus.

You also need python-uno (or python3-uno) installed on the client machines.

Configure access to your database via Tools -> Options -> LibreOffice Writer -> Odoo Options.

Troubleshooting

If you experience an empty configuration dialog or missing translations, probably your extension registry is corrupt.

rm -rf ~/.config/libreoffice/4/user/{extensions,uno_packages}

fixes the problem, but you lose all installed extensions, their configuration and you'll have to reinstall them.