I’m going crazy failing to create a half page of labels from a CSV or Database file. I eventually managed to get the CSV data into a Base table, registered it and can see it show up in the list of available data sources in the Labels wizard.
I’ve followed the Help instructions for creating mailing labels, starting with File/New/Labels.
I can see the database and the table I want to use, and it has data in it, in columns with the field names I set up from the first line of the CSV file.
I’ve included the data fields in the Label tab, used the Format tab to select Avery 7160 labels, and in the Options tab I’ve checked Entire Page and Synchronize contents. So far, so straightforward.
But when I click New Document, all I get is short form field names. No data. Like this:
(sorry, when I Quote these lines the formatting goes awry)
<Home - Street>
<Home - City><Home - State>
<Home - ZIP>
When I go to View/Field Names I get ‘long form’ field names including the database name, table name, and field name.
<Xmas North America 2018.Xmas North
America.0.First><Xmas North America
2018.Xmas North America.0.Middle Name><Xmas North America 2018.Xmas
North America.0.Last> <Xmas North
America 2018.Xmas North America.0.Home
- Street> <Xmas North America 2018.Xmas North America.0.Home - City><Xmas North America 2018.Xmas
North America.0.Home - State> <Xmas
North America 2018.Xmas North
America.0.Home - ZIP>
I simply CANNOT see how to get the data into the label document. I’ve tried multiple times, and am on the point of giving up and using MS Word 2010 to do the merge.
I eventually found the Data to Fields button, but it only appears to offer another dialogue allowing me to redo what I’ve already done in the Label wizard, to put fields onto the label.
And the Mail Merge button starts up the Letter or Email merge wizard.
I look for and fail to find a button saying ‘Do the Merge’ or equivalent.
What am I doing wrong?
WHY is it so completely non-intuitive? Why can’t LibreOffice just merge directly from a CSV file?