How to print labels using Microsoft Word


So far the only printing I am versed with is plain vanilla printing on A4 paper. There are few variations like printing in colour or printing A3 sheets. But these variations are not drastically different to what I already know.

Today I took charge to print some labels. I haven’t printed a label until now and I probably won’t have to print labels again until long time. I haven’t found a page on the Web that explains up to step by step precision. So here is an attempt to capture the gained knowledge.

I am sure you are smart enough to get the gist and adjust the steps to suit to your software and hardware setup.

Hardware and Software Needed

  1. Windows 7 PC
  2. Avery QuickPEEL labels. Normal A4 paper will do but that needs cutting labels manually as opposed just peeling off. And need glue to stick them on the consignment manually.
  3. Microsoft Word 2010
  4. Printer

Steps to Print

Open Microsoft Word. [Pro tip: Quickest way to open Microsoft Word is to Press Windows + R, type winword. Hit Enter.]

Open Mailings menu -> Labels , Enter label text in the Labels tab of the opened Envelopes and Labels dialog.

Envelopes and Labels

Click on Options… to open Label Options dialog.

Label Options

Select Page Printers and then appropriate Tray. Tray might be different depending on number of trays on your printer. But Label Vendors and Product Numbers are standard if you are using Avery QuickPEEL addressing labels.

Click OK on Label Options dialog to return to Envelopes and Labels dialog.

Click on New Document on Envelopes and Labels dialog. A new document will be created with 8 X 3 grid with label text in each cell as shown in the following partial screenshot.

Label Grid

At this stage you can adjust the Font and Cell Alignment as needed. If you are using Avery labels then font can’t be so big that the labels overflow into next page. All labels need to be on the same page so they will be printed on label sheet because ultimately you are going to peel them off to stick elsewhere. This is not a problem if you are printing on normal A4 page.

Go to File menu and select Print. Ensure Print One Sided and Portrait Orientation. Choose Copies.

Before hitting Print, ensure either tray is empty [in which case Printer complains about empty tray so you get an opportunity to place the Avery label sheet in the tray] or the first sheet in the selected tray is Avery label sheet. The tray is what you chose in the Label Options dialog above. In my example I used Tray 5.

Hit Print and see printer blissfully dispensing your label sheet with your chosen label text imprinted on each one of 24 labels (For Avery label sheets) in 8 by 3 grid. Now peel them off and stick them wherever!

My printer initially refused to accept the placed label sheet citing either page size or orientation is incorrect however it eventually relented when I adjusted the flaps that surround the paper in the tray.


  1. A colleague who supplied Avery QuickPEEL sheets and little  background on label printing.
  2. This video didn’t spoon-fed me but helped me get the idea.

iPad Air.

The cat is set out of the bag by Apple.

I am particularly excited and impressed by iPad Air though it is slightly off-putting that it lacks the TouchID.  Also I am slightly annoyed by no refresh to the Apple TV.

I wish someone could point that the following slide indeed lists New Zealand.

However this tweet is little relieving.

While I eagerly await 1 Nov, I will put my hands on Apple TV.

Flickr offers 1 TB auto upload of camera roll.

I was chuffed this evening to look at a banner in my Flickr app because as part of its latest update to iOS app, among other features, Flickr now allows users to auto upload iPhone camera roll to their 1 terabyte share of Yahoo!’s servers somewhere in the ether. I think this is a fantastic feature that is going to change the game for all other services. This is a great news for users like me who are actively seeking ways to insure their priceless photos against potential device failure, theft and few other risks.

Traditionally most of the popular cloud offerings had one or other shortcomings. I have been using Dropbox which offered a reasonable 10 GB with a very convenient auto upload  feature but both my accounts are nearly maxed out.  Skydrive offered 25 GB [for early birds]  but lacks auto upload feature from my HTC 7 Trophy that is stuck on Windows Phone 7 and the third party apps are sub-standard. I have 4 Box accounts worth 50 GB each but similar to Skydrive, there isn’t yet a nice and easy way to auto upload. Apple’s Photostream has limit of either 1000 photos or 30 days which is only good enough to sync photos across iOS devices but not for permanent storage. Facebook’s 2 GB is next to nothing and I always hated the aggressiveness of Google’s push to sign me up for Plus.

For all these reasons, I had to delete some photos of my little one-  which, by the way, are the best part of the photos on my iPhone- to manage within the limited space. Despite that, I had to be a bit moderate with the number of my clicks or review and delete the similar photos.

This is why a 1000 GB of storage with auto upload sounds like music to my ears. However there are at least two shortcomings which I am more than happy to overlook at this stage. I can’t upload my earlier photos and I can’t upload videos. But I am hopeful they will be on the road map. Even otherwise, I am delighted with what I got now. Thumbs up to Flickr for being generous with storage. Because personally, I can’t explain how much joy I experience whenever I take a look at the chronologically arranged photos of my little one.

Hopefully others will follow Flickr’s lead. I am sure, within few years even 1 TB sounds like puny and everybody wonders how we used to manage with only few tens of GB of cloud space “in those days”.

Think before you tweet

Great advice.

Re-blogged from here.

When you’re desperate or anxious or scared, that’s when you have to step back, slow down and think about what can happen in the future with your actions in the present.

The Next iPad

I had to let go of 4 iPads.

iPad 1 was too basic to justify the cost. I almost bought iPad 2 if not for the lack of retina display.  iPad 3 sported a retina display but my funds were engaged elsewhere. I exercised a bit of delayed gratification with iPad 4.

I think that’s enough of delay before gratification so I can’t wait more for next iPad. So when I saw a tweet pointing to this story on All Things D, I was delighted.  I am hopeful that Apple will host an iPad event in next few weeks.

Besides being thinner, lighter and faster than current iPad, I expect Apple will port some of the flagship features of iPhone 5S into next generation iPad. I am specifically hoping for Touch ID , 64-bit chip architecture and  better lenses on front and rear. And not to mention, iWork, iPhoto and iMovie which are free on all new iOS devices. This feature lineup sounds very exciting. There has never been a better time to own an iPad.