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

today's howtos

Openwashing

Games for GNU/Linux

  • Achieve Global Domination in Agenda, Coming to PC, Mac, Linux on September 21
    Agenda, a strategy simulation from Exordium Games where players control an evil organization seeking world domination, will come to Windows, Mac, and Linux on Sept. 21st, 2016. Players will direct covert operations to increase their control over countries' economies, political parties, militaries, science institutions and media outlets. Operations will entail everything from low key kickbacks to military leaders to the brazen assassination of political rivals.
  • Vendetta Online 1.8.385 MMORPG Drastically Improves Chat and Effect Delays
    Guild Software announced the release of a new maintenance update for their popular and cross-platform Vendetta Online MMORPG (Massively Multiplayer Online Role-Playing Game) 3D space combat title. According to the release notes, Vendetta Online 1.8.385 is an important milestone, and it's here to drastically improve the chat and effect delays reported by users during larger capship battles by implementing a new dynamic server packet-queuing and priority change system, which was tested internally with 200 close-proximity capships per battle.
  • Looks like Subnautica from the Natural Selection 2 developers won't get Linux support
    This is quite sad, it seems we have been left wondering for a while (years) about Subnautica, but a developer has now confirmed a Linux version is not being worked on.

Leftovers: Software

  • GNOME Music 3.22 to Offer Better Sorting of Songs in Albums and Artists Views
    GNOME Music 3.22 is on its way, as well as the GNOME 3.22 desktop environment, due for release next month on September 21, and it looks like we're now able to get an early taste of what's coming in GNOME's default music playback app. GNOME Music 3.22 Beta has been released, distributed as part of the first Beta development milestone of the upcoming GNOME 3.22 desktop environment, and it promises to offer better sorting of tracks in the Artists and Albums views, a "new playlist" entry to the Playlist dialog, and new keyboard shortcuts.
  • bitmath-1.3.1 released
    bitmath is a Python module I wrote which simplifies many facets of interacting with file sizes in various units as python objects. A few weeks ago version 1.3.1 was released with a few small updates.
  • NetworkManager 1.4 Released
  • NetworkManager 1.4: with better privacy and easier to use
    After we released version 1.0 of NetworkManager, it took us sixteen months to reach the 1.2 milestone. This means that it took over a year for some newly added features to reach the user base. Now we are releasing the next major release after just four months.