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

GNOME News

  • Hurrah! Dash to Dock Now Supports GNOME 3.24
    The Dash to Dock GNOME Shell Extension has been updated to support GNOME 3.24, and improves its app launch keyboard shortcut feature.
  • openSUSE Tumbleweed Is the First to Offer the GNOME 3.24 Desktop Environment
    openSUSE Project's Dominique Leuenberger was proud to announce the availability of the recently released GNOME 3.24 desktop environment into the software repositories of the openSUSE Tumbleweed rolling release. According to the developer, and to our knowledge, openSUSE Tumbleweed is now the first GNU/Linux distributions to offer the GNOME 3.24 packages to their users. We know that openSUSE is a distro mostly oriented towards the KDE Plasma desktop, but support for GNOME is provided at the same level of quality.

Linux Action Show ends after 10-year run

This past Sunday, Jupiter Broadcasting announced the Linux Action Show—one of the longest-running podcasts in the Linux world, which has aired almost continuously since June 10, 2006—is coming to an end and closing down production. Over a decade. That is a seriously good run for any show—podcast, TV, radio or otherwise. When I and my co-host created the Linux Action Show (typically abbreviated as LAS) nearly 11 years ago, we had no idea it would last this long. Nor did we have any idea of how far it would grow. Read more

Red Hat News

Samsung Z4 gets WiFi Certified with Tizen 3.0 onboard, Launching soon

Today, the next Tizen smartphone, which should be the named the Samsung Z4, has received its WiFi certification (certification ID: WFA70348) – Model number SM-Z400F/DS with firmware Z400F.001 on the 2.4Ghz band. WiFi certification is usually one of the last steps before a mobile device gets released and means a launch is coming real soon as we have already seen the Z4 make its debut appearance at the FCC. For the previous model, the Samsung Z2, we saw it get WIFi certified on 7 July and then launched on 23 August, a mere 6 weeks. Read more