Results 1 to 6 of 6

Thread: Help printing labels -- how do you do it?

  1. #1
    Join Date
    Sep 2012
    Location
    Maryland, US
    Posts
    623

    Default Help printing labels -- how do you do it?

    This really has me stumped and I have already spend several hours trying to get it working in LibreOffice.

    Can someone please explain to me how you take a list of addresses (contacts) from Google or Thunderbird or Kontact and print them on labels?

    It can be any recommended app or workflow, thanks.
    Kernel: 4.12.14-lp150.12.7-default x86_64 bits:
    64 Desktop: Gnome 3.26.2
    Distro: openSUSE Leap 15.0

  2. #2
    Join Date
    Feb 2013
    Location
    Indiana
    Posts
    267

    Default Re: Help printing labels -- how do you do it?

    Quote Originally Posted by anika200 View Post
    This really has me stumped and I have already spend several hours trying to get it working in LibreOffice.

    Can someone please explain to me how you take a list of addresses (contacts) from Google or Thunderbird or Kontact and print them on labels?

    It can be any recommended app or workflow, thanks.
    I am using gLables label designer. It is in the repositories.
    Mike

    AMD Athlon(tm) II X3 435 Processor, (RAM): 8.0 GiB, openSUSE Leap 42.2, (x86_64)
    KDE: 4.10, ATI Radeon HD Graphics

  3. #3
    Join Date
    Jun 2008
    Location
    Florida, USA
    Posts
    982

    Default Re: Help printing labels -- how do you do it?

    In the past, not real recently, I have used LibreOffice writer.

    File-New-Labels.

    Worked fine for me, similar to the Avery Label wizzard in MSWord in the bad old days....

    I have libreoffice-templates-labels-a4 and libreoffice-templates-labels-letter, both ver 1.0.1-1.1 loaded from the LibreOffice :Stable repo.
    Desk: Ryzen5 Leap 15.1
    Lap: HPDV7T i7 Leap 15.2

  4. #4
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,925
    Blog Entries
    14

    Default Re: Help printing labels -- how do you do it?

    Quote Originally Posted by anika200 View Post
    This really has me stumped and I have already spend several hours trying to get it working in LibreOffice.

    Can someone please explain to me how you take a list of addresses (contacts) from Google or Thunderbird or Kontact and print them on labels?

    It can be any recommended app or workflow, thanks.
    Like in MS Office, there's quite something needed to get this as automated as possible. You need the data (database / csv) to be added as a data source to LO
    This page is a good start https://help.libreoffice.org/Common/...Business_Cards

    Here's how I do it:
    LO - File - New - Labels
    Select the data source
    Select the table containing the address data
    Select the fields you want the content of on the labels, use the <-- to add them to the label.
    File - Print, LO will tell you it found database fields in the doc, do you want to print a standard letter, Answer yes
    Now you will be presented with options to print, incl. to print to file(s), my bet is you'll manage from there.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  5. #5
    Join Date
    Sep 2012
    Location
    Maryland, US
    Posts
    623

    Default Re: Help printing labels -- how do you do it?

    Quote Originally Posted by Knurpht View Post
    Like in MS Office, there's quite something needed to get this as automated as possible.
    Now you will be presented with options to print, incl. to print to file(s), my bet is you'll manage from there.
    Wow yes this works, I ran through this several times yesterday but was stymied at the last step. You actually have to click print to get LO to proceed with the rest of the process, very odd.
    Kernel: 4.12.14-lp150.12.7-default x86_64 bits:
    64 Desktop: Gnome 3.26.2
    Distro: openSUSE Leap 15.0

  6. #6
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,925
    Blog Entries
    14

    Default Re: Help printing labels -- how do you do it?

    Quote Originally Posted by anika200 View Post
    Wow yes this works, I ran through this several times yesterday but was stymied at the last step. You actually have to click print to get LO to proceed with the rest of the process, very odd.
    It's the most easy way for one-time jobs. But there's also the route where you don't print, but use the Tools - Mail merge option. Use the label designed doc to create the merged doc(s).
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •