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.
To begin with :
Secondly, download the model:
These templates are a document that you can customize to your liking.
Alternatively, you can:
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:
If needed, refer to Microsoft Word Help .
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.
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 .
To change the format of the document, you can use all the formatting available on Microsoft Word.
To start printing all your labels:
A document for all your labels is generated. You can now print it with your default printer.