Re: [libreoffice-users] Re: Trying to get labels to fit

Hi ptoye,

About 4 or 5 years ago when doing labels for our Christmas cards, I ran 
across the table style forms mentioned by NoOp below. I will never go 
back to the standard frame type forms standard in OO and LO. I've had 
absolutely no alignment problems. I'll also paste here some assistance 
if you are using a database to fill out the forms:

*LibreOffice Labels*
Go to insert/fields/other. In that window choose the Database Tab, then 
select mail merge, and drag the fields you want to your label form. Then 
in the same column as the mail merge selection choose next record and 
click insert. Copy the information from the first cell to the other 
cells in the template.
I don't know if this might help anyone or not. I had an OpenOffice form 
problem using the table template with a standard 30 label sheet (3 x 
10). I have all of our Christmas card addresses in an OpenOffice 
database. I have the form setup, etc, to automatically pull the address 
information in when I click print and select the database, etc. It works 
great with one exception. Last year my wife said I missed having a few 
addresses included. I didn't think anything about it, and honestly, 
didn't think that was possible. This year before giving her the printed 
labels I thought I would check that everyone was there. I set the 
printing so it is sorting to print A_Z based on the last name. It takes 
three sheets. I have 78 names in the database, but only had 76 printed 
labels. What happened was when the printing went from the first sheet to 
the second sheet, it misses one record. The rest of the second page is 
fine. When I went from the second sheet to the third sheet, once again, 
it skipped the next label, then printed fine for the balance. When I say 
it skipped it, the missing record just disappears. It isn't that I end 
up with a blank label at the top of the sheet. The next one in line to 
be printed on the first label on Page 2 vanishes and the one that should 
be the second one on the second page becomes the first one on the second 
page. The same with the third page. A person would never pick this up 
unless checking the database against the printed labels. To solve this 
problem, if you need three sheets of labels, you need three sheets in 
your template. Also, LibreOffice and OpenOffice (at least past versions) 
print out one blank page between each sheet of labels. If you print the 
document (without importing the information, so you just have the 
fields) as a text file, then delete out the blank sheets, and then save 
the text file back to your template, that problem is solved.

Don

On 12/14/2012 03:18 PM, NoOp wrote:
> On 12/14/2012 11:12 AM, ptoye wrote:
> > Trying to produce labels, but they don't fit the paper! I'm using the
> > built-in L7163 address label format.
> >
> > It's a bit complicated as I don't have a printer attached - I have to make a
> > PDF document and print it on another machine. As "Export to PDF" just gives
> > a sheet with the fields names on rather than the filled-in values, I use a
> > PDF printer and am getting different (and wrong) PDFs from both OO and LO.
> > Interestingly, the results are different between LO and OO, and also between
> > the printers I use, so there seems to be a problem with the printer
> > interface.
> >
> > With OO using CutePDF I get a US letter size document (8 by 11 inches),
> > using Bullzip I get a document 20.8 by 28.2 cm (a bit smaller than A4). The
> > pitches are also wrong.
> >
> > With LO I get the same from both printers: a correctly sized document. But
> > the pitch is wrong: 9.2 by 3.6 cm instead of 9.9 by 3.8.
> >
> > How on earth can I get OO and/or LO to produce my labels? It's too late for
> > my Xmas cards now - I've gone back to an ancient Lotus SmartSuite which
> > works perfectly. But won't run on Windows 7 unfortunately.
> ...
>
> I think this will help:
> <http://www.worldlabel.com/Pages/openoffice-a4.htm>
>    <http://www.worldlabel.com/Templates/a4/WL-SG3899.ott>
> That will provide a template (table format) for your labels. You might
> consider ordering from Worldlabel... they are the only vendor that I
> know of that provide OOo/AOO/LO templates for their products.

--


**


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted