grexx
asked on
OpenOffice: printing address labels in Calc?
I have a spreadsheet with addresses that I need to print on labels (A4, 7 x 3). Is there a way to get this done? I remember that I once did something like this in MS Office, converting the addresses from Excel to Word, then printing them. I don't care if I need Writer or not, just want to print the addresses. I can edit the sheet as needed of course. I use NeoOffice 2.0 (alpha) on Mac OSX.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You asked the question as Open Office, which is manageable. Now this NeoOffice? which one, please?
ASKER
Thanks mtz1of4. I'll try that tonight. NeoOffice is OpenOffice for the Mac, running as a Java application. There is an OpenOffice version for the Mac that requires X11. NeoOffice is a bit slow, but it does the job. The version is 2.0 Alpha, which is functionally the same as OO 2.0. I've had no problems yet with this alpha version. The beta is out in three weeks I believe.
ASKER
It worked! I had to take several small hurdles, but in the end I got it.
First, adding a data source table was a problem as I didn't know I had to create a database for that. Then I had problems with the Next Record insert, apparently didn't do that properly the first time, so all labels got the same information. Then it created only one page, while I had records for several pages. But it was worth it, and afaik it's easier than I can remember from the Excel to Word method.
First, adding a data source table was a problem as I didn't know I had to create a database for that. Then I had problems with the Next Record insert, apparently didn't do that properly the first time, so all labels got the same information. Then it created only one page, while I had records for several pages. But it was worth it, and afaik it's easier than I can remember from the Excel to Word method.
I have problems printing multiple pages. See:
https://www.experts-exchange.com/questions/24537864/OpenOffice-Labels-prints-only-one-page.html
https://www.experts-exchange.com/questions/24537864/OpenOffice-Labels-prints-only-one-page.html