Re: [libreoffice-users] Mail Merge and Labels

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