How to Print Labels Using Word and Excel

It is quite frustrating to print thousands or even hundreds of labels manually. Holiday season is coming around so it would be good to have a quick and easy way to print labels. Lets see how you can do it in style.


If I say there are no better softwares than Words and Excel for manage data I think I am correct. Knowing all the Excel hacks and tricks you can get any sort row data in to organize manner. Arrange it exactly you want. Using Word you can arrange them to print it the way you want it. This is exactly what you required to print labels without wasting time.

First you must organize the information you have. This includes identifying the needed information and collect correct and up to date information. Google Docs Forms will come handy on collecting information. Because straight away it puts into Excel Spread Sheet. No need to spends time organizing the gathered information.
For example if you need to collect all the mailing addresses of your friends, relatives or even business partners to send seasonal greetings simple you can create a Google Doc Form with relevant field (Name, Address, Suburb, State) send the link to everyone to fill. You will end you with nice and clean excel full of names addresses.

After collecting all the required information and organize them we need to look in to a way to print it as labels. I will move all the collected data to Microsoft Excel from Google Docs as we going to used Microsoft Word for formatting. Microsoft word to print labels from Excel Step by step guide will give you a idea how to do it. Here are couple of tips that will clear things out.

When you create the original Excel make sure you create heading in vertically. (eg: Row 1) Then the data for each heading going downward.That means if you take one row it contains all the information required for one label.

Mail Merge Recipients dialog box will takes you through all the steps. When it comes to select the label type make sure you give exact information about the label you need to print. I find it easy to keep actual paper in front of me and provide the measurements accordingly.

If you want to print couple of labels in one sheet then you need to specify in the Label Options. All the standard labeling sizes can be found there already.

Each template need to be copy and paste into the other labels in the same page with the <> to display next available record in the next label. Then you can directly print it out.

It is quite easy process and if you have any questions I would be happy to help you out.