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

Hi Virgil,
They have really worked well for me. With the frame based templates, I always had trouble with the spacing on the labels changing as you would get into the bottom third of the label sheet. The frame based templates print out perfectly from top to bottom, and they are so easy to adjust. I've left similar posts when people have had issues before, but it seems very few are willing to try the table based formats. Maybe they try to use the wizard, which is not the way to set up a table based template. 

Don

On 12/16/2013 08:11 PM, Virgil Arrington wrote:

Don,

Thank you for this. I knew I had seen something like that before.
LO uses a frame based label template. I agree that a table based template makes far more sense. 

Virgil

-----Original Message----- From: Don C. Myers
Sent: Monday, December 16, 2013 7:34 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels

About 5 or 6 years ago when using OpenOffice to print Christmas labels,
I ran across an article about using table style labels in OpenOffice
instead of the type which come with Word, OpenOffice, and LibreOffice.
It is far easier to adjust the table style labels. To adjust the top
spacing, simply adjust the top margin for the page. To adjust the column
width, simply drag the column borders and the entire column is adjusted.
At one time OpenOffice had these label templates available as an
extension. I don't know if they still do or not. But they are available
from World Label here:
http://www.worldlabel.com/Pages/openoffice-template.htm
They can be downloaded individually, or all together as a pdf.

I've found them much easier to use and adjust, and have never used any
other label templates since then. Also, when you enter the text or
fields in them, the text is starts with being paced in the center of the
label between the top and the bottom, and then as additional lines are
added, the text of fields are automatically centered within the label
itself, top to bottom. I've never used the standard templates with
OpenOffice or LibreOffice since finding these. Nor have I wasted any
sheets of labels because they didn't print properly.

Don



On 12/16/2013 05:07 PM, John Clegg wrote:
I have just done my labels too - only using Avery 8165 (I just happened to 
have some in the drawer) It worked find, but I too found the printing
started right on the edge - and I couldn't see any way to change this other than adding spaces manually. I had to add a blank line at the top for the 
same reason. Or is there a way that I have missed?


On 5 December 2013 23:37, Jeff Hahn <hahn.jp@outlook.com> wrote:
I use LO 4.1.3 and Windows 7. I should repeat that in my case the first 2 columns print properly (although the print starts right at the edge of the 
label).  It is only the third (right) column that is off.

Jeff Hahn


From: cuyfalls@hotmail.com
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels
Date: Thu, 5 Dec 2013 12:31:46 -0500
I just noticed this thread, and I have to chime in that, the last time I 
tried to create labels, I too noticed that the LO Avery 5160 template
alignment was off. I had to adjust the contents of every cell. At that

time,
I was still using LO 3.5.x. I have not yet tried since upgrading to the 
4.x.x range.
At the time, I just installed Apache OO, as its template worked properly.
If I recall correctly, I think there may have been other label templates 
online as extensions that worked better than LO's label template.

Virgil

-----Original Message-----
From: Niklas Johansson
Sent: Thursday, December 05, 2013 12:20 PM
To: Jeff Hahn ; users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels

So I looked at the configuration in LibreOffice 4.0.6 and LibreOffice
4.2 beta-version and the configuration seems to be correct. I even
compared it to the result that I get in Word 2013 for the same label
(sorry for not thinking about doing that earlier). So before I put
anymore time into this it would be good to know what version of
LibreOffice you used when you created the labels?

Niklas Johansson

Jeff Hahn skrev 2013-12-05 17:22:

I think the configuration in the wizard may be wrong.  The Avery 5160

has

30 labels on a 8.5" x 11" sheet each measuring 1" x 2 5/8".  It is
probably one of the most common labels used so I am surprised the issue 
hasn't previously been raised.  As I indicated in my email, I didn't

have

any problem when I switched to Word so I am reasonably confident the

issue

is not related to my printer.

Jeff Hahn



Date: Thu, 5 Dec 2013 17:04:24 +0100
From: sleeping.pillow@gmail.com
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Mail Merge and Labels

Hi Jeff

Is the issue that you used lable sheets of the type Avery 5160 and

that

the preconfiguration for these lables were wrong?
I think that I remember reading some issues with the label

functionality

(File -> New -> Label) in an earlier version of LibreOffice that

might

or might not be fixed in newer versions. What version of LibreOffice

did

you use?
Do you have any specifications for the measurements of these specific 
labels so I can do a quick review if there seems to be any issues

there?
Note also that you can tweak the measurements under the Format tab of the Labels-dialog. Not that you should need to if you use labels that 
has a preset configuration.

Kind regards,
Niklas Johansson

Jeff Hahn wrote 2013-12-04 16:41:



I tried to do my labels for Christmas
cards using LO's mail merge. I was able to create the data base and
print without difficulty. Unfortunately, the entire third column

was not

properly spaced and printed outside of the label, a couple of

spaces to the left. The first two columns were they were supposed to

be. I

was using standard

configuration for Avery 5160. I finally gave up created the labels
with Excel and Word.




I am not sure where to send an email to
suggest that the matter be looked into so I am sending this
information to this list with the hope the matter will be picked

for

investigation. Also, although I suspect it has been suggested
before, it would be nice to be able to do a mail merge directly

from

the spreadsheet without creating a database file.




Jeff Hahn




--
To unsubscribe e-mail to: users+unsubscribe@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


--
To unsubscribe e-mail to: users+unsubscribe@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


--
To unsubscribe e-mail to: users+unsubscribe@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
--
To unsubscribe e-mail to: users+unsubscribe@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






--


**


--
To unsubscribe e-mail to: users+unsubscribe@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

Context

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.