[Solved] I need help with OpenOffice label creation

Discuss the word processor

[Solved] I need help with OpenOffice label creation

Postby zanna » Thu Mar 31, 2016 5:22 pm

i have read all the help prints on open office and have yet to get my labels printed.

i have a spreadsheet with all the information for the labels but I must be missing something. help please
Last edited by zanna on Fri Apr 15, 2016 9:11 pm, edited 1 time in total.
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: i need help with open office label creation

Postby thomasjk » Thu Mar 31, 2016 5:32 pm

I recommend http://openoffice.blogs.com/openoffice/ for a wealth of older but still applicable help. I also suggest this article http://www.freesoftwaremagazine.com/art ... office_org.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4387
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: I need help with OpenOffice label creation

Postby John_Ha » Sun Apr 03, 2016 3:07 pm

... or see [Solved] Labels: not merging and db updates problem for step by step instructions to printing labels where addresses are contained in a spreadsheet.

If this solves the problem, please click the Edit button on your original post and add [Solved] in front of your subject.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I need help with OpenOffice label creation

Postby DiGro » Sun Apr 03, 2016 5:22 pm

____________
DiGro

AOO 4.1.5 on Windows 10. Scanned with ZIGGO Safe Online (F-Secure)
User avatar
DiGro
 
Posts: 68
Joined: Mon Oct 08, 2007 1:31 am
Location: Hoorn NH, The Netherlands

Re: I need help with OpenOffice label creation

Postby zanna » Sun Apr 03, 2016 9:38 pm

yes I did
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: I need help with OpenOffice label creation

Postby zanna » Sun Apr 03, 2016 9:44 pm

John_Ha wrote:... or see [Solved] Labels: not merging and db updates problem for step by step instructions to printing labels where addresses are contained in a spreadsheet.

If this solves the problem, please click the Edit button on your original post and add [Solved] in front of your subject.



You mention XLS files...I can not find what you are asking for. zanna
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: I need help with OpenOffice label creation

Postby John_Ha » Mon Apr 04, 2016 12:13 am

zanna wrote:You mention XLS files...I can not find what you are asking for. zanna

A .xls file is a spreadsheet file - you can also use .odt files. I wrote it many years ago when I was still using .xls files.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I need help with OpenOffice label creation

Postby zanna » Mon Apr 04, 2016 1:55 pm

thank you John
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: I need help with OpenOffice label creation

Postby zanna » Tue Apr 05, 2016 1:55 pm

Almost there:
1. Formatted my labels
2. Yes to print form letter
3. Mail Merge : high-lighted all lines and selected "all"
4. Print Screen came up : checked my printer and "all pages"
5. Hit Print
A sheet with labels came out -------no input from the spreadsheet on them.

Please : what did I do wrong or not do ?
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: I need help with OpenOffice label creation

Postby John_Ha » Tue Apr 05, 2016 1:59 pm

Try following the step by step instructions - it looks like you did not register the database / spreadsheet.

Note that you MUST have a database (which you never actually seem to use) as well as a spreadsheet. Writer talks to the spreadsheet through the databsase.

Or see Chapter 11 - Using Mail Merge in the OOo v3.3 Writer Manual
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I need help with OpenOffice label creation

Postby zanna » Wed Apr 06, 2016 8:19 pm

Sorry to bother you.
I printed out the pages from the manual...thank you for sending the address to it.
I am still having a problem :

I register the file and I check to see it is registered ....it said yes.
I then go to print the labels.
The Mail Merge screen comes up and shows the file name listed on the left and the all the data listed on the right of the screen.
I then select Print and I ask for the first 6 records.
The data doesnot move to the labels only the format prints out.

I have tried this six times now and have pulled all my hair out (joking)
Why isn't the data moving to the labels format ?
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: I need help with OpenOffice label creation

Postby MrProgrammer » Wed Apr 06, 2016 9:45 pm

Hi, and welcome to the forum.

zanna wrote:Why isn't the data moving to the labels format ?
Use the Data to Fields button on the toolbar to transfer the database content to your Writer document after selecting the database rows.
Screen Shot 2016-04-06 at 14.43.04 .png

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3609
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: I need help with OpenOffice label creation

Postby thomasjk » Thu Apr 07, 2016 1:36 am

If all you are seeing in the print out is the actual field names then Press Ctrl-F9 to tun off View Field Names.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4387
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: I need help with OpenOffice label creation

Postby zanna » Thu Apr 07, 2016 3:16 pm

The "Data to Fields" button is not highlighted.
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: I need help with OpenOffice label creation

Postby Villeroy » Thu Apr 07, 2016 3:54 pm

BiblioLabels.odt
Subsequent labels made from "Bibliography" database.
(9.68 KiB) Downloaded 35 times

BiblioLabelsMerged.odt
Subsequent labels from "Bibliography" database printed to document.
(11.23 KiB) Downloaded 55 times


One selected record:
1. Remove all [NextRecord] fields from the BiblioLabels.odt
2. Print serial
3. Select one particular record by clicking on a grey row header box.
4. Select "File" as output medium.
This is the result.
BiblioLabels2Merged.odt
Sheet for a single label record made from "Bibliography" database printed to document.
(9.3 KiB) Downloaded 25 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26376
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: I need help with OpenOffice label creation

Postby John_Ha » Thu Apr 07, 2016 6:23 pm

zanna

In reply to a private message ...

It is difficult to know from what you are saying.

Try the files in the next post (only three files or images allowed per post!) which I have built for you and see if you can get them to work.

names.odt - a spreadsheet with two names and addresses

Names Database.odb - the required database

Avery 7160 labels sheet for printing labels.odt - A document created by the File > New > labels dialogue, using Avery 7160 labels which have 3 columns of 7 labels on an A4 sheet.

Labels from names spreadsheet.pdf
- the result

After you have downloaded them all into the same folder, then

1 Open names.odt
2 Open Names Database.odb
3 For your first attempt, use Avery 7160 labels sheet for printing labels.odt document which I created for you. Open it with Writer. File > Print ... It says "Your document contains address ...do you want to print a form letter?" Choose YES

4 Click the first address line at the green > arrow on the left

5 Hold shift, click the 2nd line (or 21st if you have more names). All lines are now highlighted blue.

6 Click OK and choose your printer ... and the labels print.

For your second attempt, do 1 and 2 above. Now create your own label sheet by:

7 File > New > Labels. This opens the Labels pop-up.

Database: choose Names Database
Table: choose Sheet 1
Database field: Choose Salutation, then click the big left arrow - this moves the Salutation field into the white box. Repeat for Name, Address 1, Address 2 and Address 3.

All the field descriptors will appear on one line in the box, so put a space between the Salutation and Name field descriptors. Put an Enter after Address 1 and after Address 2.
This lays out the label as
Mr Name
Address 1
Address 2
Address 3


Brand: Choose Avery A4
Type: choose L7160 Address (3 columns with 7 labels per column.

Click New document. File > Save As ..., and call it My first labels document.odt.

print dialogue.png
The print dialogue


labels dialogue.png
The labels dialogue


document.png
What the form letter looks like before going File > Print ...
document.png (6.31 KiB) Viewed 3879 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I need help with OpenOffice label creation

Postby John_Ha » Thu Apr 07, 2016 6:24 pm

The files ...
Attachments
Avery 7160 labels sheet for printing labels.odt
the .odt file to print the labels
(11.87 KiB) Downloaded 40 times
Names Database.odb
the database
(1.68 KiB) Downloaded 22 times
names.ods
the spreadsheet
(9.17 KiB) Downloaded 43 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I need help with OpenOffice label creation

Postby John_Ha » Thu Apr 07, 2016 6:25 pm

The result ...
Attachments
Labels from names spreadsheet.pdf
The result
(20.05 KiB) Downloaded 56 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: I need help with OpenOffice label creation

Postby zanna » Fri Apr 15, 2016 9:06 pm

SOLVED thank you John
Open Office 4.1.2 on Windows 10
zanna
 
Posts: 8
Joined: Thu Mar 31, 2016 5:12 pm

Re: [Solved] I need help with OpenOffice label creation

Postby John_Ha » Fri Apr 15, 2016 10:57 pm

I think the problem was due to Java 32 bit not being installed - critically, Java seems to be needed for the database linking. I await zanna's confirmation.

See Java & Apache OpenOffice which says

Java is mainly required for the HSQLDB database engine (used by our database product Base) and to make use of accessibility and assistive technologies. Furthermore some wizards rely on Java technology.

Be aware that OpenOffice requires 32 bit Java even if you have a 64 bit machine running 64 bit Windows.

Important note for all Windows users:
The Windows version of OpenOffice is 32-bit and therefore it requires a 32-bit JRE even when you have a Windows version with 64-bit installed. Furthermore you have to install a 32-bit JRE - additionally or instead - when you already have a 64-bit JRE installed.

So, even though you are almost certainly running Windows 7 or Windows 10 64 bit, you MUST install the 32 bit version of Java for OpenOffice. This means you may have both 32 bit and 64 bit Java installed on your PC.

You can check which version of Java you have by looking where it is installed. On my Windows 7 64bit machine, 32 bit Java is located at C:\Program Files (x86)\Java\ whereas 64 bit Java is located at C:\Program Files\Java.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6439
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Writer

Who is online

Users browsing this forum: No registered users and 27 guests