« Modify the Layout of Prefab OpenOffice Labels Under File > New > Labels | Main | All Orders as of 8 AM Today Have Been Shipped »

December 13, 2006

Comments

Boy, have labels been a thorn in my side. Despite all the trying and retrying, labels are a pain in OpenOffice.org. Now that's not something I like saying, but it's true. Don't take it too hard, though, because Word isn't much better. After a lot of trial and error, I decided that maybe a word processor isn't ideal for labels. I then began my search for dedicated label printing software. If you're still using Windows (too bad) then Avery makes a decent (free) program that works pretty well. If, however, you've graduated to Linux, then you owe it to yourself to try gLabels. I have been using it for several months, and I shall never print labels with a word processor again. It does mail merges from CVS files (export them from Calc!) with EASE. You can easily drop in pictures and barcodes. The interface is brilliant. It will even resize your text on a per label basis AUTOMATICALLY to prevent runoff!! I know this is an OpenOffice.org blog, but my experience with gLabels has shown me the mailing-label-merge light. Also, I have absolutely no affiliation with anyone involved with gLabels. Try it. That's my best tip for printing labels in Linux. Sorry to be off topic.

Hi Louis,

Thanks for the tip -- I'm all about the easiest way. Mail merge from CSV sounds good. I'll check it out!

Solveig

I have just tried glabels, and yes think it will save me tearing my hair our with OOO's dreadful label procedure (which doesn't work for me). But the glabel instructions are a bit lacking. Here's what to do:

Click on 'T' (Create text object) and click in the Left hand side label box.
You'll get a movable box with "TEXT" in it.
In the RHS you edit this text like this:
${1} ${2}
${3}
${4} ${5}

Those numbers are the fields in your csv file, e.g.
Firstname, Surname, Address, Town, Postalcode

You should also select the font and fontsize for these, the defaults are rather big.

Now save the label layout at this stage so you can use it again (file open) without having to recreate it.

Then go to [Objects][Merge Properties] and choose the file and records to include in the labels.

Select Print then Print Preview and you should see the labels.

Hi Tony,

Thanks for the tips on gLabels!

Solveig

I just wanted to second the advice on using gLables. I created labels using OO going through the many steps and finally, finally when I was done the labels printed too far to the left. I adjusted margins, paper size, etc., couldn't get it to work. So I get gLables, the instructions are not the greatest but I used Tony's advice (above) and got labels printing perfectly.

Thanks

Hi there,

It is a lot easier to print labels manually when you have templates to guide you, i had many problems with getting the text to print within the margains until i decided to download these templates which did help me out a lot. These days though i no longer have the time for printing my own address labels[/url] out so now have to use a british labels company to print them out for me.

http://www.selfadhesivelabels.com/products.html

Hi there,

It is a lot easier to print labels manually when you have templates to guide you, i had many problems with getting the text to print within the margains until i decided to download these templates which did help me out a lot. These days though i no longer have the time for printing my own address labels[/url] out so now have to use a british labels company to print them out for me.

http://www.selfadhesivelabels.com/products.html

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place, i will must refer this information with reference on my website i.e www.electrocomputerwarehouse.com

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place, i will must refer this information with reference on my website i.e www.electrocomputerwarehouse.com

We make sure that you completely understand the impact and the effectiveness of our social bookmarking submission service, by offering you a free submission

thanks for a very intresitng support

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog