To generate labels, you can use the mail merge functions of the Microsoft or Google suite tools.

We specify below a step-by-step tutorial to print production labels (use by) or in INCO format from Microsoft Word.

Prepare your documents

To begin with :

• Schedule your production and indicate which tasks are completed: they feed into the INCO label view;
• Go to the list of production labels in the traceability section,
  To print the DLC labels during processing, or to label your finished products in a simplified format, not subject to the INCO regulations.
• Go to the list of INCO labels in the traceability section,
  To print the labels of prepackaged products ready to be marketed;
• Apply the right filters to get a list of relevant documents;
• Click on Export to obtain an Excel file containing all the data useful for labeling.

Secondly, download the model:

• INCO label template
• Production Label Template (Use by)

These templates are a document that you can customize to your liking.

Alternatively, you can:

• use a solution dedicated to label printing and import the Excel file;
• subscribe to the API module and perform a custom integration between melba and a third-party templating service.

How to import data into a model

Once you have the data in an Excel file and a label template, you can link the two.

Our model is by default linked to the file you download. Arrange them in the same directory. When opening Microsoft Word offers to update the document, accept or search for the downloaded Excel file if it is not recognized.

If the connection is not automatic:

• Open the Word template for labels;
• In the ribbon, click on Mailings then Select recipients then Use an existing list;
• Load the downloaded Excel file.

If needed, refer to Microsoft Word Help .

How to generate a label for each line

In the template, you can switch between rows of data via the Mailings ribbon and the Preview Results section.

It shows changes. These changes are localized where the model contains formulas to retrieve data from the Excel file.

To see the rendering of each line, just click on the previous and next buttons in this section.

How to change template formulas

Display rules depend on formulas.

When clicking on the data that can change, they are highlighted. You can right-click and then Toggle Field Codes or Toggle Field Codes .

This brings up a formula surrounded by braces. You can change these formulas using the dedicated Microsoft Word help .

How to change the document format

To change the format of the document, you can use all the formatting available on Microsoft Word.

Specifically :

• To change the size of the label: go to the ribbon, Layout section then Margins and Size;
• To change the typography: go to the main ribbon.

How to start printing

To start printing all your labels:

• Go to the Mailings ribbon , Finish / Finish & Merge section ;
• Choose the Edit individual documents option.

A document for all your labels is generated. You can now print it with your default printer.