How to print labels the EASY way! – Video Tip

You can learn and start using this tip TODAY to make Christmas card or group mailings a breeze. AND, I’ve included a template for you at the end of the article (below the video).

Too many computer users have no idea what a database is, how to use it, and how to merge it with another program to create labels. Since printing mailing labels is only a once per year activity for many of you, learning how to do it again every single year requires too much time and frustration.

In this week’s tip, I take all of the mystery and hysteria out of creating and printing mailing labels. You will thank me every November when you need to print out your mailing labels. The tip centers around creating a word processing document where you can store, edit and print your labels quickly and easily. Watch the video as many times as you need to and you will NEVER be frustrated with printing labels again!!

If you can’t understand and utilize this tip to print your labels, get out your best pen and write them out instead.

Another way to create labels easily is to use Avery’s online method. Read and watch my tip here.

Click here to download the label template for Avery 5160 or 8160 labels…the most common type of mailing label.

Print Friendly, PDF & Email

33 Comments

  1. Patty June 3, 2009 Reply

    You are wonderful. I’ve been so frustrated.
    Thank you, thank you, thank you.
    Patty

    • Author
      Rick June 4, 2009 Reply

      You are welcome Patty. Thanks for stopping by and I hope you keep coming back for more practical tips and tech information. And don’t forget to tell your friends!

    • Jacqueline January 20, 2012 Reply

      Thank you so much! I have saved hours of time at work!

  2. Gary Teresi November 18, 2010 Reply

    What about printing index cards?
    Gary

    • Author
      Rick November 19, 2010 Reply

      Can be accomplished exactly the same way Gary…if you are talking about the tearable kind from Avery. Individual cards are a little harder and also depend on the paper handling abilities of your individual printer.

  3. Anne December 15, 2010 Reply

    Label time of year again! I do them in word. The original was easy…A couple of years ago. But now that I’ve made deletions, it seems I can’t simply put in another name & address in the deleted (blank) spot.
    Whether I use tab, space, or ctrl tab, the cursor goes to the next label position. But not at the top line, to start with a name. Why is that? What’s the solution? What am I doing wrong? I considered simply creating another label template. But that seems a lot of work vs a simple update.
    Thanx anyone…:)

  4. Sara Cardwell December 15, 2010 Reply

    Your last computer seminar was most informative in re address labels. I had been laboriously loading addresses into an Xcel spreadsheet data base I had created myself; I was going to sort them alphabetically, then load them into a Word label document. However time was running out. OK, OK, I collapsed under the pressure & in a fit of anxiety over getting those Christmas cards addressed, I purchased & downloaded StatTrak address software. It’s a user-friendly handy little database that is quite sophisticated for the price – $29.99. I got everything loaded, labels printed & Rich got the labels on the cards w/an investment of a couple hours from start to finish.

    If you hadn’t confirmed my opinion that programmers don’t send Christmas cards, I never would have explored label software. As I mentioned, I have Access but that is a hydroelectric dam when what was needed was a battery charger.

    I thought I’d share this handy software & say Thanks for your classes. We’re just sorry we’ve missed so many of them.

    Sara/Rich

  5. George Hale January 2, 2011 Reply

    I have a question on Avery Lables. I hase a couple of packs that are about 15 plus years old. Never used any.

    Are theysaft to use in my Laser Printer now ? Or will they fall off inside the printer.

    I read some where that you should ust the whole sheet. I only need a couple of lablel now and then.

    Thanks
    George
    GJ, CO

  6. Gordon November 24, 2011 Reply

    I am mot impressed with your advice on making labels. I am using the Open Office method. Can you advise, I find the type is too near the edge of each label, when I do a test. Can I move the text to the centre of the label?
    Look forward to hearing from you and I will certainly be visting you again

    Regrds

    • Author
      Rick November 27, 2011 Reply

      This tip truly is the easiest way to make labels for folks who have a hard time making labels. If you are having trouble with positioning, you can adjust margins and tabs to position it better for yourself.

  7. sharon March 6, 2012 Reply

    i have been having trouble to print labels, since i had my computer cleanded out & worked on I have been having trouble trying to make labels.

    i was told that i could still print labels, but i haven’t been able to find
    the file.

    i sure do miss not being able to print labels for my private files, address labels.

    i’ll keep trying to find ,

  8. Tracy April 30, 2012 Reply

    Is there a way to alphabatize the labels once you get them typed?

  9. GINA May 3, 2012 Reply

    AWESOME! THANK YOU!!!

  10. Ellen Robinson July 11, 2012 Reply

    I like to all a touch of color when addressing Christmas card “envelopes”. Is it difficult to add a small “clip art” candy cane or Christmas Bells or Minature Christmas tree when using labels? Think I will start using labels this year.
    Thanks!
    Ellen

  11. Pat Vicari November 6, 2012 Reply

    Thank you so much. Tried quite awhile and different sights, yours was wonderful.

  12. Steve Olis November 27, 2012 Reply

    I have created my mailing list of addresses for Christmas just like the video shows using MS word 2010 with no problems. I can print one label per page or I can print the same label on the page 30 times. I want to print my list of different address on the page so I have 30 different labels to mail. I cannot get that done in the label section. If I print with the normal going to file, then print, I get the file to print out but not formatted for the type of labels I am using. I just don’t see how I can do the different address labels to print in the label tab.
    Thank you,

    • Author
      Rick November 28, 2012 Reply

      Thanks for writing. All the answers are in the video…watch carefully and you will be printing labels in no time! Thanks for stopping by!

  13. Steve Olis November 28, 2012 Reply

    I have the problem solved on printing the labels. Somehow, I got a top margin on page one that was non-standard (smaller) than the other pages. This was throwing every label off. I could not find a way of deleting the first page only, so I cut and pasted each address into a new label file. The result was great and the top margin on all of the pages were fine.

    • Author
      Rick November 30, 2012 Reply

      Great to hear!

  14. Geraldo November 30, 2012 Reply

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each
    time a comment is added I get several e-mails with the
    same comment. Is there any way you can remove me from that service?
    Thank you!

    • Author
      Rick November 30, 2012 Reply

      Look at the bottom of one of the notification emails and you can opt out at any time.

  15. Airlie December 9, 2012 Reply

    This was sort of helpful. I was hoping to be able to create a document from my email Christmas card list and “insert” the addresses into the template (?) for the 5160 Avery address labels.

    I don’t want to have to type all the names into the template/form. As you can see, I an not very computer label literate.

    I somehow managed to print labels last year, but am having a lot of difficulty this year.

    Help!

    • Author
      Rick December 12, 2012 Reply

      Yes, you can do this IF your Christmas card list is in database format AND you know how to work with Mail Merge in your word processor. Otherwise, this is the thrust for my tip. Yes, it takes time up front the first year, but after that it is cake.

  16. Liz December 10, 2012 Reply

    Is there a way to alphabetise the lists? We have about five pages of addresses and like to keep track of who replies etc. but when we take people off, and add others, the lists get all screwed up.

    • Author
      Rick December 12, 2012 Reply

      No way to alphabetize after you setup the initial labels, but it is very fast to use Ctrl+F (find function) to quickly locate a name to edit or remove from your list. Good luck!

  17. bshirk4 January 6, 2013 Reply

    how can i do this on a mac

  18. Kristen March 26, 2013 Reply

    Howdy would you mind letting me know which webhost you’re utilizing? I’ve loaded your blog in 3 different web browsers and
    I must say this blog loads a lot quicker then
    most. Can you recommend a good web hosting provider at a honest price?
    Kudos, I appreciate it!

    • Author
      Rick March 27, 2013 Reply

      Try Hostgator.com They offer good support and value.

  19. Truegreen July 18, 2013 Reply

    This design is steller! You most certainly know how to keep a
    reader entertained. Between your wit and your videos,
    I was almost moved to start my own blog (well, almost.
    ..HaHa!) Wonderful job. I really enjoyed what you had to say,
    and more than that, how you presented it. Too cool!

    Feel free to surf to my web site – Truegreen

  20. Jiggypiggy August 24, 2013 Reply

    Thank you so much! So glad I found this information. I have used computers at work since they were invented, but after early retirement and getting a new laptop after my old pc crashed with all my databases and mail merges already set up, I have been mystified as to how I used to set up a new address database and mail merge from scratch, even after having done it a million times while working and even showing others how to. It seems that a simpler way can be overlooked as an alternative method to look for. Need to think more outside the box 🙂 Thanks again, and I will follow all your tips from now on with interest.

  21. Ralph April 26, 2017 Reply

    How can one subsequently alphabetize a page of labels?

  22. Maggie September 27, 2017 Reply

    Thank you so much!! I can’t believe it was that fast to get my job done here!! you made it simple and i wanna thank you for showing how to do the label, or else i would spend hours of trying to get it done. you are awesome!

    • Author
      Rick September 27, 2017 Reply

      Awesome! Glad it worked out for you. Thanks for visiting and come back often!

Leave a reply

Your email address will not be published. Required fields are marked *

*