At least you could test the labels I have prepared for you, so see how it is intended to work.
Open the file.
Hit Ctrl+F9 repeatedly in order to see the <placehoder names> and what they refer to.
Print.
Answer "Yes" when prompted if you want to print a form letter. "No" would print the label sheet as shown on screen.
Choose "All Records" and "Output = File" instead of "Printer", specify a file name, confirm the dialog and wait some seconds.
Open the specified file. It contains the result of the mail merge.
The first mail merge fields refer to "Bibliography.biblio.Identifier"
"Bibliography" is the name of some database. You as a Writer user don't have to bother about the location nor type of that database.
"biblio" is the name of a table within that database.
"Identifier" is the name of a column within that table.
Hit F4 (menu:View>Data Sources) in order to open the data source window. It looks like this:

On the left there is a tree view with registered names of databases, tables within these databases and queries within these databases.
Can you see your own data source and tables in the data source window?
On the right side you see table data after you clicked one of the tables.
Can you see your data by clicking on a table name?
If you see your list data in the data source window:
1) Get the right label template from
http://www.worldlabel.com/Pages/template_1.htm2) Fill one of the table cells with mail merge fields, line breaks and with one [Next] field (menu:Insert>Fields>Other...Database).
3) Copy the table cell content into the other cells.
Edit: If you don't see your list data in the data source window: |
menu:File>New>Database...
[X] Connect to existing database
Type: Spreadsheet
Specify the spreadsheet file
[X] Register the database
Save, close and forget the database but do not delete it.
Nothing has been copied, converted nor exported by any means. The data are still in the spreadsheet.
After editing the spreadsheet, you have to restart the whole office suite before the changes take place in the labels.
Edit: There are better sources than spreadsheets. |
Notice that you can edit the "Bibliography" data source directly in the data source window and any changes take place immediately. The "Bibliography" is connected to a dBase directory. Create a dedicated database directory and save you spreadsheet as dBase file (*.dbf) in that directory. Only the active sheet of a spreadsheet document is saved as one dBase table. Then connect a new database document to the dBase directory or change your existing database document so it is linked to the dBase directory instead of the spreadsheet (menu:Edit>Database>Connection... type:dBase)