Language Selection

English French German Italian Portuguese Spanish

Openoffice.org mailing labels solution

My daughter is getting married this Summer, and she purchased some weird Avery return address labels for invitees to RSVP whether they plan to attend. The labels have an Avery number of 18195. I have no MS-Windows workstations at home, and I couldn't find an Openoffice.org Writer template for this particular label stock. What to do?

The labels are 2/3 inch tall, 1 3/4" wide, 4 across in a row, and 15 rows on an 8 1/2" by 11" (US letter size) sheet. I still can't find a corresponding OOoWriter template. Nothing even close.

I do a Google search, and try glabel. It seems very powerful--alas, after fooling around with it for a few minutes, I'm not able to get very close to what I need for a label format.

Then, I go to Avery's web site, and download Avery's Microsoft Word doc file template for the 19195 labels. I then open it into Openoffice.org 3.0 Writer beta (m-17). The doc file is a table. I type the return address into one cell, copy that address, and quickly paste the address info into the other 59 cells. I try a print-out on a plain piece of paper and then I examine the printed registration match-up with the Avery label stock. No joy, the table rows on the test print-out aren't tall enough.

In Writer, I select the entire table, pull up the row height option, and see that the doc file import had set the row height to .60 inches instead of the needed .67 inches (or possibly, Avery had it incorrect in the original doc file). I change the row height accordingly, print-out another plain paper copy, and check the registration again. Everything lines up. A minute later, and all my labels are perfectly printed.

More in Tux Machines

Leftovers: Software

  • GNU Guile 2.2.1 released
    We are happy to announce GNU Guile release 2.2.1, the first bug-fix release in the new 2.2 stable release series.
  • Announcing Nylas Mail 2.0 [Ed: just Electron]
  • Cerebro Is An Amazing Open Source OS X Spotlight Alternative For Linux [Ed: also just Electron]
    You may be fed up with traditional way of searching/opening applications on your system. Cerebro is an amazing utility built using Electron and available for Linux, Windows, and Mac. It is open-source and released under MIT license.
  • Flowblade Another Video Editor for Linux? Give It A Try!
    You may have favorite video editor to edit your videos but there is no harm to try something new, its initial release was not that long, with time it made some great improvements. It can be bit hard to master this video editor but if you are not new in this field you can make it easily and will be total worth of time.
  • Get System Info from CLI Using `NeoFetch` Tool in Ubuntu/Linux Mint
  • Ukuu Kernel Manager Utility lets You Upgrade or Install Kernels in Ubuntu/Linux Mint
    There are many ways to upgrade your Linux Kernel using Synaptics, command line and so. The Ukuu utility is the simply solution to manager your Ubuntu/Linux Mint kernels. If you want to test new fixes in the Linux Kernel then you can install Mainline Kernels released by Ubuntu team but mainline Kernels are intended to use for testing purposes only (so be careful).
  • 10 Reasons Why You Should Use Vi/Vim Text Editor in Linux
    While working with Linux systems, there are several areas where you’ll need to use a text editor including programming/scripting, editing configuration/text files, to mention but a few. There are several remarkable text editors you’ll find out there for Linux-based operating systems.
  • OpenShot 2.3 Linux Video Editor New Features
    It’s been quite some time since we last talked about OpenShot, and more specifically when it had its second major release. Recently, the team behind the popular open source video editor has made its third point release available which happens to come with a couple of exciting new features and tools, so here is a quick guide on where to find them and how to use them.
  • Boostnote: Another Great Note Taking App for Developers? Find Out By Yourself
    Boostnote is an open-source note-taking application especially made for programmers and developers, it is build up with Electron framework and cross-platform available for Linux, Windows and Mac. Being programmers, we take lots of notes which includes commands, code snippets, bug information and so on. It all comes in handy when you have organized them all in one place, Boostnote does this job very well. It lets you organize your notes in folders with tags, so you can find anything you are looking for very quickly.
  • Collabora Office 5.3 Released
    Today we released Collabora Office 5.3 and Collabora GovOffice 5.3, which contain great new features and enhancements. They also contains all fixes from the upstream libreoffice-5-3 branch and several backported features.

Virtualization and Containers

GNOME News

today's howtos