Skip to content

GENERATE MAIL-MERGED LABELS FROM AN AD-HOC REPORT

Create Label Template

  1. Launch OpenOffice Writer.

  1. OpenOffice Writer defaults all documents to be in a book style format and you should amend the print settings as follows to avoid printing a blank page between each printed page.

  2. Click the Tools Menu and Options.

  3. Click the + symbol to the left of Open Office Writer

  4. Remove the tick from Print Automatically Inserted Blank Pages.

There is no facility to save this modification to an existing document, so click File>Save As and save the document as your new template. Open this new template to continue.

  1. Now select New>Labels from the File menu.

The aim is to add data tokens to the Label Text box which identify the data fields to be displayed on the label.

  1. Open Office remembers the data tokens from the previous template. If there is a tick in the Address tick box, remove this tick, and if there are any tokens already in the Label Text box, you can delete these if they are not relevant and add new tokens, as follows:

  2. In the Database drop down box, select MiddleMan.

  3. In the Table box, select AdHocMMerge.

  4. In the Database Field box, will be a list of tokens that can be > added to the label template. They are numbered Col01-Col99 and > these relate to the order in which the data columns are displayed > in your ad-hoc report, ie Col01 is the first column, etc. There > are also additional tokens for Customer Ref (CustomerRef) and > Animal Ref (AnimalRef) if you need these and they are not already > displayed in the report.

  5. To add your field tokens to the template, select the token in the > Database Field box; place your cursor in the Label Text > box where you would like the token to be positioned; and then > click the arrow to the left of the token name to move the token to > the Label Text box.

  6. When all of the tokens have been added:

  7. in > the Format section click Sheet;

  8. in the Brand box, select the brand of labels that you are using, > eg Avery A4;

  9. In the Type box, select the label reference for the type of > labels that you are using, eg L7160 or L7161.

  10. Click New Document and the new document now becomes your label template. Save this template.

Run the Ad-hoc Report

  1. Select Reporting>Ad-hoc Reporting.

  1. Click Open then browse for and double-click the required report.

  2. Execute the report, the results will be displayed on the bottom half of the screen for checking.

Complete The Merge

  1. Click Merge on the toolbar.

  1. Browse for and select the template and click Open.

  2. The document will open ready for you to print onto your A4 labels.