Link to home
Start Free TrialLog in
Avatar of grexx
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
Avatar of Marc Z
Marc Z
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You asked the question as Open Office, which is manageable.  Now this NeoOffice?  which one, please?
Avatar of grexx
grexx

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.
Avatar of grexx

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.