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.
You are wonderful. I’ve been so frustrated.
Thank you, thank you, thank you.
Patty
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!
Thank you so much! I have saved hours of time at work!
What about printing index cards?
Gary
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.
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…:)
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
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
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
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.
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 ,
Is there a way to alphabatize the labels once you get them typed?
AWESOME! THANK YOU!!!
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
Thank you so much. Tried quite awhile and different sights, yours was wonderful.
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,
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!
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.
Great to hear!
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!
Look at the bottom of one of the notification emails and you can opt out at any time.
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!
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.
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.
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!
how can i do this on a mac
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!
Try Hostgator.com They offer good support and value.
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
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.
How can one subsequently alphabetize a page of labels?
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!
Awesome! Glad it worked out for you. Thanks for visiting and come back often!
Comments are closed.