Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

There is an openoffice extension for all different label forms in table form, which have worked marvelously well for me. I haven't checked if the are available in LibreOffice or not. You can also download the complete set of forms from The link is on the right hand side of their home page. Worldlabel seems very supportive of open source!

On 03/01/2011 03:25 AM, James Wilde wrote:
In another email I said that I had given up on using mailmerge, since the labels never print out as 
you want them to.  My problem is this:

I have a laser printer, Brother HL-5340D, excellent in all ways.  I print from a Mac running OSX 
10.6.6 and LibO 3.3.1.  I use A4 sized sheets with three columns and eight rows of labels.

Avery L7159 has the same number of labels but they are slightly different.  On the Avery L7159 
format, the labels have a small vertical margin between labels.  On my sheets, there is no vertical 
margin.  This should actually be better for my problem, but doesn't help.

What I get when I print is the first column of labels begin to print at the extreme left margin so 
that a couple of letters are missing, notwithstanding that the Avery labels don't actually extend 
to the extreme left margin.  The second column starts printing in the middle of the margin between 
labels 1 and 2, so that the first letter comes at the extreme left edge of the label. The same 
thing happens with label 3, which, additionally prints all the way to the extreme right edge, 
notwithstanding that the Avery label doesn't extend all the way to the extreme right edge, so that 
letters are missing from long names or addresses which don't wrap as they should.

I have tried creating my own custom label template, but there are so many other problems with the 
mailmerge system that I've given up.  For example, what I get when I manage to get labels with the 
wizard is this:

Page 1 contains one row of the A's, three of them, of course, then 7 rows of labels with field names.  Page 2 starts 
with the fourth name in the list and continues "normally", as do subsequent pages.  I place 
"normally" in quotation marks since the normal form of the labels is, as I said earlier, lacking letters on 
each label.

If any kind soul has a custom template which they think works with labels of this type, Avery L7159 
or ones which extend to the extreme left and right edges, and is willing to share it, I'll give 
them, perhaps not gold, but undying admiration and gratitude.

But basically, I think the mailmerge system could do with a good working over.  That, or the 
instructions on how to use it, either manually or with the wizard.  Fortunately my labels are only 
around 200, for our local gardening club, so I can cope with doing it more or less manually, but it 
would be nice to be able to automatise it.




Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at <>
_View Don's Farm Web Site at <>

Unsubscribe instructions: E-mail to
List archive:
*** All posts to this list are publicly archived for eternity ***


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.