Learn Ubuntu MATE
  • Home
    • Screen Tearing on Intel Graphics
    • Screen Tearing on AMD Graphics
    • How to install Realtek WiFi Driver >
      • How to install Realtek WiFi Driver (Pt 2)
    • Authentication is Required to Mount
    • Traditional Menu
    • Software >
      • App Grid
      • AppCenter
      • GNOME Software
      • Modern Apps
    • Welcome & Software Boutique
    • Remove Welcome & Software Boutique
    • TeamViewer
    • Simple How to Tips >
      • Change Wallpaper
      • Pin a Program
      • Change Date & Time
      • Enable Screensavers >
        • Cosmos Screensaver
      • Decrese Icon Padding
      • Enable Magnification
      • Fading Windows
      • Replace Clock Indicator
      • Remove Media Players
      • Fix ​​Error Mounting
      • Create a Submenu
      • Remove the Collection Menu
      • Preferred Applications
      • Upgrade LibreOffice
      • Install Fonts >
        • Install New Fonts
      • Play a DVD
      • Enable Livepatch
      • ESM-Apps
      • Update Software
      • Unresponsive Program
      • Install HWE >
        • Install HWE 20.04
      • Open HEIC Images
      • Open WebP Images
      • Packages Kept Back
      • USB Flash Drive
      • No Audio
      • Screen Flickering
      • Screen Blanking
      • Draining Battery
      • Reduce Shutdown Time
      • Create a Mount Point
      • Thunderbird Emoticons
      • Sound Preview
      • Failed To Download >
        • Failed to Download (#2)
      • Enter Password to Unlock
      • Two Wifi Icons
      • System Program Problem
      • CD Burner Issue
      • Firefox Homepage Fix
      • VLC Closes Fix
      • Desktop Error
      • Trash Bin
      • MATE Weather Applet
      • OpenGL: renderer: llvmpipe
      • PolicyKit vulnerability
    • Install Ubuntu MATE >
      • Burn an ISO to DVD
      • Create a Bootable USB
      • Upgrade Ubuntu MATE
  • Ubuntu MATE
    • How to Scan
    • How to Take a Screenshot
    • How to View a PDF File
    • Multiple Workspaces
    • Software Updater
    • Archive Manager
    • How to Burn CD/DVDs
    • Setup & Use Email >
      • Email Filter
      • Upgrade Thunderbird
    • Firefox Web Browser
    • Shotwell Photo Manager
    • Image Viewer
    • Caja File Manager
    • Trash
    • Play Videos
  • Additional Software
    • Antivirus >
      • BitDefender Antivirus
      • ClamTK Antivirus >
        • Clamscan Antivirus
        • ClamTK Caja Add-on
      • Comodo AntiVirus
    • Archive Managers >
      • Archive Manager
      • Ark
      • B1 Free Archiver
      • P7Zip-Desktop
      • PeaZip
      • Xarchiver
    • Browsers >
      • Brave
      • Chrome
      • Chromium
      • Falkon
      • Firefox
      • GNOME Web
      • Iridium Browser
      • LibreWolf
      • Microsoft Edge
      • Midori
      • Min Browser
      • NAVER Whale
      • Opera
      • Otter
      • Pale Moon
      • SeaMonkey
      • Sidekick
      • Slimjet Browser
      • SRWare Iron
      • Thorium
      • Ungoogled Chromium
      • Vivaldi
      • Waterfox
      • Yandex Browser
    • Office Applications >
      • Couturier
      • PDF-Shuffler
      • PDF Studio Viewer
      • Xournal
      • Foxit Reader
      • Okular
      • gLabels >
        • Multiple Name Badges
        • CD & DVD Labels
        • Business Cards
        • Mailing Address Labels
        • Return Address Labels
      • Font Downloader
      • Calendar
      • Pcal
      • Spice-Up
      • Stickynotes
    • Educational Programs >
      • Galculator
      • GeoGebra Classic
      • GNOME Calculator
      • KCalc
      • NumWorks
      • Pebbles
      • Qalculate!
      • QT-Calculator
      • How To Install R >
        • Install R Commander
        • Install RStudio
      • SpeedCrunch
      • TI-83 Plus
      • TI-84 Plus CE
      • KWordQuiz
      • Granule
    • Graphics >
      • 4K Slideshow Maker
      • Imagination
      • Gnome Screenshot
      • Ksnip
      • Shutter >
        • Shutter 0.94.3
      • PhotoFlare
      • Pinta >
        • Tool Palette >
          • Tool Palette (Cont)
        • File Menu >
          • Screenshot Tool
        • View Menu
        • Edit Menu >
          • Palette
        • Image Menu >
          • Image Size
        • Layers Menu
        • Adjustments Menu >
          • Invert Colors
        • Effects Menu >
          • Red Eye Removal
          • Pixelate
        • Add-ins Menu
        • Window Menu
        • Help Menu
        • Restore Layout
        • Pinta 1.7
        • Pinta 2.0.1
        • Pinta 2.1.1
      • Bing Wallpapers
      • Variety Wallpaper
      • Converseen
      • Curtail
      • Imagine
      • ​Annotator
      • Aliza MS
      • Brightness Controller
      • Gifcurry
      • Photoprint
      • Peek
    • Image Viewers >
      • Deepin Image Viewer
      • Eye of Gnome
      • Fotoxx
      • Geeqie
      • GPicView
      • gThumb
      • Gwenview
      • Mirage
      • nomacs
      • PhotoQt
      • Phototonic
      • Pix
      • Qimgv
      • qView
      • Ristretto
      • Viewnior 1.6 >
        • Viewnior 1.7
      • XnView MP
      • Xviewer
    • Music Players >
      • Amarok
      • Audacious
      • Clementine
      • DeaDBeeF
      • foobar2000
      • Guayadeque
      • Lollypop
      • Museeks
      • Noise Music Player
      • Pragha
      • Quod Libet
      • Rhythmbox
      • Sayonara
      • Strawberry
      • Violin
    • Networking >
      • Dukto
      • LAN-Share
      • Nitroshare
      • Warpinator
    • Utility Software >
      • BleachBit
      • Stacer
      • Ubuntu Cleaner
      • CPU-G
      • CPU-X
      • Hardinfo
      • I-Nex
      • Alarm Clock
      • Caffeine
      • Conky >
        • Widgets & Themes
        • Title Bars
      • deb-get
      • GNOME Split
      • GParted
      • GtkOrphan
      • Ice SSB >
        • MS Office Online
        • Pixlr Editor
        • Photopea
      • KRename
      • KShutdown
      • Magnus
      • Meteo
      • Radeon Profile
      • Ubuntu Mainline Kernel Installer
      • Y PPA Manager
    • Sound & Video >
      • Avidemux >
        • Merge Videos
        • Cut Videos
        • Crop Videos
      • Selene
      • Radio Tray >
        • Radio Tray Lite
      • Pithos
      • Spotify
      • Asunder
      • EasyTag
      • SimpleScreenRecorder
      • OBS Studio
      • FF Multi Converter
      • FFmpeg
      • SoundConverter
      • MediaInfo
      • Bomi
      • Gnome MPV
      • MPlayer
      • SMPlayer
      • VLC Media Player
      • HandBrake >
        • Convert A Video
        • Boost Audio
    • Entertainment >
      • Hypnotix
      • IPTVnator
      • Airy TV
      • Crackle
      • Plex Live TV
      • Pluto TV
      • Popcornflix
      • Stirr TV
      • Tubi TV
      • Xumo TV
      • YouTube Movies
      • Plex Media Server
      • Emby Media Server
    • Themes & Colors >
      • Themes
      • Installing Themes
      • Customize Themes #1
      • Customize Themes #2
      • Change App Icons
    • USB Image Writer Tools >
      • Bootqt
      • Etcher
      • GNOME MultiWriter
      • MX Live-USB Maker
      • Popsicle
    • Diagnostics >
      • Hiren's BootCD PE
  • Reviews
    • YouTube Reviews >
      • Ubuntu MATE 16.10
      • Ubuntu Mate 17.04
      • Ubuntu MATE 17.10
      • Ubuntu MATE 18.04
      • Ubuntu MATE 20.04
      • Ubuntu MATE 22.04
  • Info
    • How Safe are Your Paasswords >
      • Cyber Security Leaks
      • Hotmail Leak
      • YaHoo Leak
      • Windstream Hacked
    • Windows 7
    • Wireless USB Adapters
  • About
    • In Memory of ...

Create Address Labels

Picture
gLabels is a powerful program that allows you to print mailing labels. For example, if you are a teacher and want to mail each of your students parents and/or guardians, then gLabels is the perfect program for you. The main office gives each teacher a copy of parental contact information in case of an emergency. This data can be put into a spreadsheet and saved as a CSV (.csv) file and merged into gLabels. It's also a great way to create your address labels for mailing out your Christmas cards each year.

In the steps below I will use Avery 5162 Address Labels template to match the name tags from Amazon (Avery Address Labels with Sure Feed for Laser Printers, 1-1/3" x 4", 1,400 Labels, Permanent Adhesive (5162)).


Create Mailing Address Labels

Before you can print address labels with multiple names and addresses you must first prepare a source document that contains your merge data. I will use LibreOffice Calc spreadsheet program to create my list of names and addresses. (All of the names and addresses in the list below are fake. I created these names and addresses to use as examples to illustrate how to print address labels using multiple names and addresses.) If you use MS Excel at school or work, you can create a list in that program too. I created a title on top of my list. This title will become my placeholder or field name that you will see on the address label until you print the address labels, print to file, or use print preview on your address label list. You can create many titles like mailing address, state, zip code, telephone number, and etc. I created a list using more titles than I will use in my examples below. This will iluustrate that you can pull only the data you need out of a file that you plan to merge into your address label. 
Picture
After you create your list and save it as a spreadsheet file, click on the File menu and then click on Save As... When the Save dialog box appears, give the file a name and change the format to Text CSV (.csv), select a loction and then click the Save button. 
Picture

When the Confirm File Format dialog box appears, click on the Use Text CSV Format button. 
Picture
An Export Text File dialog box will appear. Make sure the Character set is set to Unicode (UTF-8), the Field delimiter set to a common (,), and String delimiter set to ". Then click the OK button. 
Picture
Open the gLabels application and then click on the Create a new file button on the toolbar or click the File menu and click the New option. 
Picture
When the Select Product dialog box appears, change the Category to Mailing/shipping products to shorten the list of label options and then scroll down and find Avery 5162: Address Labels and click it to select it. 
Picture
Then click the Next button. A Choose Orientation dialog box will appear to allow you to select the orientation or  position of your address labels.  Select Normal for horizontal positioned name tag.
Picture
Then click the Next button. You have a chance to look over your choices you have made up to this point in the Review Selection dialog box. You can use the Back button if you noticed that you've made a mistake. 
Picture
Click the Apply button to start creating your address labels. 
Picture
You are now ready to merge the .csv file that contains all the names and addresses. To start this process, click on the Objects menu and then on Merge properties option. 
Picture
When the Merge Properties dialog box appears, click the down arrow to the right of the Format option. Then select Text: Comma Seperated Values (CSV) with keys on line 1. 
Picture
Then click on the folder icon to the right of Location option. 
Picture
Locate the file that contains the names and addresses. It will have a file extension of .csv. Then click the Open button. You will see a preview of the list of names in the Record/Field section.
Picture
You can click on an arrow to the left of any of the names to see the titles and content of each title. You can unselect any names that you do not won't to print a label for. Click the OK button when you are ready. 
Picture
You won't notice anything just yet; however, you will when you add new text to the label. Click the Create text object (T) button on the toolbar and then click the location you want your student name.  Delete the word Text under the Text tab. Then click the drop down arrow next to Insert Merge Field.
Picture
Select a field name that you want to start with on your mailing address label. You can start with first or last name. In my example below, I will start with the last name field name or placeholder.
Picture
I continue to add the field names in the locations that I would normally add a name and  address on a typical mailing address label. I click the Create text object (T) button on the toolbar each time I wanted to start adding a new line.
Picture
I recommend that you save your mailing address labels after you complete the placement of all the field names or placeholders. Click the Save current file button to save you file.
Picture
Give the file a name that you will recognize in the future and select a location for the file. Then click the Save button.   
Picture

You can preview the address labels before you print them. To preview the address labels, click the File menu, then click on the Print... option. 
Picture
When the Print dialog box appears, click on the Labels tab at the top. Click on the print outlines (to test printer alignment) under Options to see what your address labels will look like. Then click the Preview button at the bottom to give you a closer look at your address labels. 
Picture
Look over your address labels and make any necessary changes before you save and print your file. 
Picture
When you are finally satisfied with the look of your address labels, you are ready to print them. Insert the Avery 5162 Address Labels stickers in your printer and then click the File menu in gLabels, then click the Print... option, and when the Print dialog box appears, click the Print button.
Picture

<Create Return Address Labels>


gLabels Manual

Picture



​​Office Applications | Home | Educational Programs

Sep 28, 2018
Powered by Create your own unique website with customizable templates.
  • Home
    • Screen Tearing on Intel Graphics
    • Screen Tearing on AMD Graphics
    • How to install Realtek WiFi Driver >
      • How to install Realtek WiFi Driver (Pt 2)
    • Authentication is Required to Mount
    • Traditional Menu
    • Software >
      • App Grid
      • AppCenter
      • GNOME Software
      • Modern Apps
    • Welcome & Software Boutique
    • Remove Welcome & Software Boutique
    • TeamViewer
    • Simple How to Tips >
      • Change Wallpaper
      • Pin a Program
      • Change Date & Time
      • Enable Screensavers >
        • Cosmos Screensaver
      • Decrese Icon Padding
      • Enable Magnification
      • Fading Windows
      • Replace Clock Indicator
      • Remove Media Players
      • Fix ​​Error Mounting
      • Create a Submenu
      • Remove the Collection Menu
      • Preferred Applications
      • Upgrade LibreOffice
      • Install Fonts >
        • Install New Fonts
      • Play a DVD
      • Enable Livepatch
      • ESM-Apps
      • Update Software
      • Unresponsive Program
      • Install HWE >
        • Install HWE 20.04
      • Open HEIC Images
      • Open WebP Images
      • Packages Kept Back
      • USB Flash Drive
      • No Audio
      • Screen Flickering
      • Screen Blanking
      • Draining Battery
      • Reduce Shutdown Time
      • Create a Mount Point
      • Thunderbird Emoticons
      • Sound Preview
      • Failed To Download >
        • Failed to Download (#2)
      • Enter Password to Unlock
      • Two Wifi Icons
      • System Program Problem
      • CD Burner Issue
      • Firefox Homepage Fix
      • VLC Closes Fix
      • Desktop Error
      • Trash Bin
      • MATE Weather Applet
      • OpenGL: renderer: llvmpipe
      • PolicyKit vulnerability
    • Install Ubuntu MATE >
      • Burn an ISO to DVD
      • Create a Bootable USB
      • Upgrade Ubuntu MATE
  • Ubuntu MATE
    • How to Scan
    • How to Take a Screenshot
    • How to View a PDF File
    • Multiple Workspaces
    • Software Updater
    • Archive Manager
    • How to Burn CD/DVDs
    • Setup & Use Email >
      • Email Filter
      • Upgrade Thunderbird
    • Firefox Web Browser
    • Shotwell Photo Manager
    • Image Viewer
    • Caja File Manager
    • Trash
    • Play Videos
  • Additional Software
    • Antivirus >
      • BitDefender Antivirus
      • ClamTK Antivirus >
        • Clamscan Antivirus
        • ClamTK Caja Add-on
      • Comodo AntiVirus
    • Archive Managers >
      • Archive Manager
      • Ark
      • B1 Free Archiver
      • P7Zip-Desktop
      • PeaZip
      • Xarchiver
    • Browsers >
      • Brave
      • Chrome
      • Chromium
      • Falkon
      • Firefox
      • GNOME Web
      • Iridium Browser
      • LibreWolf
      • Microsoft Edge
      • Midori
      • Min Browser
      • NAVER Whale
      • Opera
      • Otter
      • Pale Moon
      • SeaMonkey
      • Sidekick
      • Slimjet Browser
      • SRWare Iron
      • Thorium
      • Ungoogled Chromium
      • Vivaldi
      • Waterfox
      • Yandex Browser
    • Office Applications >
      • Couturier
      • PDF-Shuffler
      • PDF Studio Viewer
      • Xournal
      • Foxit Reader
      • Okular
      • gLabels >
        • Multiple Name Badges
        • CD & DVD Labels
        • Business Cards
        • Mailing Address Labels
        • Return Address Labels
      • Font Downloader
      • Calendar
      • Pcal
      • Spice-Up
      • Stickynotes
    • Educational Programs >
      • Galculator
      • GeoGebra Classic
      • GNOME Calculator
      • KCalc
      • NumWorks
      • Pebbles
      • Qalculate!
      • QT-Calculator
      • How To Install R >
        • Install R Commander
        • Install RStudio
      • SpeedCrunch
      • TI-83 Plus
      • TI-84 Plus CE
      • KWordQuiz
      • Granule
    • Graphics >
      • 4K Slideshow Maker
      • Imagination
      • Gnome Screenshot
      • Ksnip
      • Shutter >
        • Shutter 0.94.3
      • PhotoFlare
      • Pinta >
        • Tool Palette >
          • Tool Palette (Cont)
        • File Menu >
          • Screenshot Tool
        • View Menu
        • Edit Menu >
          • Palette
        • Image Menu >
          • Image Size
        • Layers Menu
        • Adjustments Menu >
          • Invert Colors
        • Effects Menu >
          • Red Eye Removal
          • Pixelate
        • Add-ins Menu
        • Window Menu
        • Help Menu
        • Restore Layout
        • Pinta 1.7
        • Pinta 2.0.1
        • Pinta 2.1.1
      • Bing Wallpapers
      • Variety Wallpaper
      • Converseen
      • Curtail
      • Imagine
      • ​Annotator
      • Aliza MS
      • Brightness Controller
      • Gifcurry
      • Photoprint
      • Peek
    • Image Viewers >
      • Deepin Image Viewer
      • Eye of Gnome
      • Fotoxx
      • Geeqie
      • GPicView
      • gThumb
      • Gwenview
      • Mirage
      • nomacs
      • PhotoQt
      • Phototonic
      • Pix
      • Qimgv
      • qView
      • Ristretto
      • Viewnior 1.6 >
        • Viewnior 1.7
      • XnView MP
      • Xviewer
    • Music Players >
      • Amarok
      • Audacious
      • Clementine
      • DeaDBeeF
      • foobar2000
      • Guayadeque
      • Lollypop
      • Museeks
      • Noise Music Player
      • Pragha
      • Quod Libet
      • Rhythmbox
      • Sayonara
      • Strawberry
      • Violin
    • Networking >
      • Dukto
      • LAN-Share
      • Nitroshare
      • Warpinator
    • Utility Software >
      • BleachBit
      • Stacer
      • Ubuntu Cleaner
      • CPU-G
      • CPU-X
      • Hardinfo
      • I-Nex
      • Alarm Clock
      • Caffeine
      • Conky >
        • Widgets & Themes
        • Title Bars
      • deb-get
      • GNOME Split
      • GParted
      • GtkOrphan
      • Ice SSB >
        • MS Office Online
        • Pixlr Editor
        • Photopea
      • KRename
      • KShutdown
      • Magnus
      • Meteo
      • Radeon Profile
      • Ubuntu Mainline Kernel Installer
      • Y PPA Manager
    • Sound & Video >
      • Avidemux >
        • Merge Videos
        • Cut Videos
        • Crop Videos
      • Selene
      • Radio Tray >
        • Radio Tray Lite
      • Pithos
      • Spotify
      • Asunder
      • EasyTag
      • SimpleScreenRecorder
      • OBS Studio
      • FF Multi Converter
      • FFmpeg
      • SoundConverter
      • MediaInfo
      • Bomi
      • Gnome MPV
      • MPlayer
      • SMPlayer
      • VLC Media Player
      • HandBrake >
        • Convert A Video
        • Boost Audio
    • Entertainment >
      • Hypnotix
      • IPTVnator
      • Airy TV
      • Crackle
      • Plex Live TV
      • Pluto TV
      • Popcornflix
      • Stirr TV
      • Tubi TV
      • Xumo TV
      • YouTube Movies
      • Plex Media Server
      • Emby Media Server
    • Themes & Colors >
      • Themes
      • Installing Themes
      • Customize Themes #1
      • Customize Themes #2
      • Change App Icons
    • USB Image Writer Tools >
      • Bootqt
      • Etcher
      • GNOME MultiWriter
      • MX Live-USB Maker
      • Popsicle
    • Diagnostics >
      • Hiren's BootCD PE
  • Reviews
    • YouTube Reviews >
      • Ubuntu MATE 16.10
      • Ubuntu Mate 17.04
      • Ubuntu MATE 17.10
      • Ubuntu MATE 18.04
      • Ubuntu MATE 20.04
      • Ubuntu MATE 22.04
  • Info
    • How Safe are Your Paasswords >
      • Cyber Security Leaks
      • Hotmail Leak
      • YaHoo Leak
      • Windstream Hacked
    • Windows 7
    • Wireless USB Adapters
  • About
    • In Memory of ...