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

Microsoft and Linux

GNOME News

  • gnome-boxes: Coder’s log
    So another two weeks have passed and it’s time to sum things up and reflect a little on the struggles and accomplishments that have marked this time period, which was quite a bumpy ride compared to the others, but definitely more exciting.
  • GNOME Keysign 0.6
    It’s been a while since I reported on GNOME Keysign. The last few releases have been exciting, because they introduced nice features which I have been waiting long for getting around to implement them.
  • Testing for Usability
    I recently came across a copy of Web Redesign 2.0: Workflow That Works (book, 2005) by Goto and Cotler. The book includes a chapter on "Testing for Usability" which is brief but informative. The authors comment that many websites are redesigned because customers want to add new feature or want to drive more traffic to the website. But they rarely ask the important questions: "How easy is it to use our website?" "How easily can visitors get to the information they want and need?" and "How easily does the website 'lead' visitors to do what you want them to do?" (That last question is interesting for certain markets, for example.)

SUSE Leftovers

  • Newest Tumbleweed snapshot updates KDE Applications
    The latest openSUSE Tumbleweed snapshot has updated KDE Applications in the repositories to version 16.04.3. Snapshot 20160724 had a considerably large amount of package updates for Tumbleweed KDE users, but other updates in the snapshot included updates to kiwi-config-openSUSE, Libzypp to version 16.1.3, yast2-installation to version 3.1.202 and Kernel-firmware to 2016071
  • Highlights of YaST development sprint 22
    openSUSE Conference’16, Hackweek 14 and the various SUSE internal workshops are over. So it’s time for the YaST team to go back to usual three-weeks-long development sprints… and with new sprints come new public reports! With Leap 42.2 in Alpha phase and SLE12-SP2 in Beta phase our focus is on bugs fixing, so we don’t have as much fancy stuff to show in this report. Still, here you are some bits you could find interesting.