Videos/Address labels in Writer

Foreword
The basis of this description here is the LibreOffice help:

LibreOffice 7.1 Help

The video shows how to create address labels under LibreOffice Writer and links to this page here, which provides further information and details.

This description refers to the LibreOffice 7.1 version on Windows 10.

Link to the Video
Link to the Video (in German [DE]):

Adress-Etiketten erstellen in Writer - LO71

Open label wizard
Use the menu to open the "Labels" Dialog.

Label text
Enter the text you want to read on the label.

Address
If you set a check mark at "Address", the address that is stored in LibreOffice will be taken.

You can reach this address via the menu.

Database
Select a database to serve as the data source for the label.

Sheet
Select the database sheet with the fields to be inserted into the label.

Database field
To add a specific database field to the "Label text", select it and then click the arrow to the left of that field.

The name of the database field is displayed in brackets in the "Label text".

If desired, the database fields can be separated by spaces.

Press the key to insert a database field in a new row.

Format
You can either select one of the predefined label formats or define your own format in the "Format" tab.

Continuous
Use this to print labels on continuous paper.

Sheet
This prints the labels on a page in tabular form.

Brand
Select the desired label brand.

Each brand has its own formats.

Type
Select the desired label type of the brand (company) you preset in "Brand".

If you click on the downward pointing arrow in the "Type" selection field on the right, the available label types will be displayed in a list.

To use a user-defined label format, first select [User] for the type and then click on the "Format" tab, where you define the format.

Button "Help"
If you click on the button, the LibreOffice help for "Labels" will be displayed.

For info
At the bottom of the "Format" area, the label type and the format of the label (the dimensions) are displayed.

Tab Format


In the "Format" tab you define the format of the labels to be printed.

If you have already specified the brand and type in the "Labels" tab, you will see the dimensions for the labels and the sheet.

If you have selected [User] in the "Labels" tab, you can enter your desired dimensions here in the "Format" tab.

Horizontal pitch
Displays the distance between the left edges of adjacent labels.

For custom formats, enter the desired value here.

Vertical pitch
Displays the distance between the top edges of two adjacent labels.

For user-defined formats, enter the desired value here.

Width
Displays the width of the label.

For custom formats, enter the desired value here.

Height
Displays the height of the label.

For user-defined formats, enter the desired value here.

Left margin
Displays the distance between the left margin of the page and the left margin of the first label.

For custom formats, enter the desired value here.

Top margin
Displays the distance between the top margin of the page and the top edge of the first label.

For user-defined formats, enter the desired value here.

Columns
Enter how many labels the page should contain in width.

Rows
Specify how many labels the page should contain in height.

Page width
Specify the page width of the custom document.

Page height
Specify the page height of the custom document.

Save
When you click the button, the current label is saved.

The "Save Label Format" dialog appears.

Brand
Enter the desired brand here or select a brand from the list.

Alternatively, enter a term of your choice.

Type
Here you can enter or select a label type, alternatively [User].

The preview field
The preview field shows a preview of the current Label selection.

Tab Options




To enter more text, do formatting, or insert images and graphics, you can synchronize content of all labels.

To do this, place a check mark next to "Synchronise contents".

If you activate this option and exit the "Labels" dialog using the button, a small window will open with the  button.

Now you only have to work on the first label of the document (top-left).

By clicking the button, the content from the first label will be copied to all other labels in the document.

Distribute - Entire page
Creates a whole page of labels.

Distribute - Single Label
Creates a single label on a page.

Distribute - Column
Specify how many columns the labels should appear in on the page.

Distribute - Row
Specify in how many rows the labels should appear on the page.

Distribute - Synchronize Contents
Allows you to edit only the first label and click the button to update the contents of all remaining labels on the page.

In Document - Synchronise Labels
The button is only visible in the document if you selected the "Synchronise Contents" option in the "Options" tab when creating the labels.

The contents of the first label at the top left will be copied to the rest of the labels on the page when the button is pressed.

Printer
Displays the name of the currently selected printer.

The button opens the "Printer Setup" dialog.

Documentation / Manuals
Here you will find the Documentation / Manuals:

Documentation / Manuals

Ask site
For questions on the topic go to:

https://ask.libreoffice.org/c/english/5

Get Involved
Join us today and help us to make it even better!

Get Involved

Donate
LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.