Creating a Label Template in Office 2016

Office 2016 Microsoft Word has some differences to past versions of Microsoft Word, but creating labels remains just as easy.

All you need is a ruler, and your labels. You just need to know where to click.

Follow the clicks in the picture.
Click 1 is a click on the Mailing tab
Click 2 is a click on Labels, and this opens the Envelopes and Labels dialog box.
Click 3 is a click on the picture of the label, and this opens the Label Options dialog box
Click 4 is a click on the New Label Button, and this opens up the Label Details dialog box, and this is where you’ll put in all of the details of the label.
Now you can get measuring and create your own label template.

How to create a label template

M-5352 10 Up Copier Labels

The M-5352 Labels are 10 up (10 labels per sheet) that can be used in all plain toner copiers. These labels are great because they take up almost all of the real estate on the page which offers more space to print, whereas the ML-1000 has small borders on the left and right.
If you’re having trouble creating a template, no need to fret, we’ve created a template specifically for the M-5352.

Click on the picture below to download the template:

Maco M-5352 10 up White Copier Labels

Viewing Microsoft Word Cell Grid lines -Seeing the Label Update

In our old post we showed how to make Cell Grid Lines visible in Microsoft Word 2007. We’ll need an update to that. It’s pretty much the same, now it just looks different. For Microsoft Word 2010, or Office 365, you’ll find it under the Design tab, then click on Borders, and select “View Gridlines” from the drop down menu.

View Microsoft Word Cell Grid Lines

The cat address labels above are on the ML-3000 address labels.

Microsoft Excel Import from CSV Tip for Printing Correctly Formatted Zip Codes on Address Labels

When you get a list from a client in CSV (comma separated values) format that you’re going to print address labels, or any kind of project , there are occasions when you’d like to import and work on the list in excel. However, when you import your data into Microsoft Excel 2016 and earlier versions, the zip code field, if you have one is recognized as a number. So after the import, all of the records with leading zeros, get stripped of leading zeros. All of the states in the northeastern united states with leading zeros are turned into 4 digit numbers. The Puerto Rico zip codes have two leading zeros and show up as three digit numbers.

The way around this is pretty straightforward:

1. Open your CSV file in a text editing program like notepad or Notepad++ (my personal favorite), and select and copy all of the data to the clipboard. You can use Ctrl-a, then Ctrl-c.
2. Open a blank Excel document, click inside the first cell, Cell A1, and the paste entire contents of the clipboard by typing Ctrl-v.
3. The first column should be selected after pasting, if not, select the first column, and click Data, then “Text to Columns”
4. Chose Delimited, and click Next, then choose Comma and ” for text qualifier then click Next
5. Choose “Text” for column data format for each column. (unless you have number that you need to sum()). The Zip code field format should be formatted as Text. Although it’s a number, keeping it formatted as Text will preserve the leading zeros.

Now you’ll have correct zip codes with leading zeros.

Weather Resistant Address Label Template

You don’t have to go far to download a template for our weather resistant address labels You can use our ML-3000 template, or the Avery® 5160 template. Or you can just click on the picture below.

Weather Resistant Address Label

These labels can be used for applications where there are poor weather conditions or moist environments. The ML-3050W weather resistant address labels are made of water-resistant material. They are Tear-proof, and have permanent adhesive. For use in both laser and ink jet printers.

Address Labels – An Alternate Use

If you’ve got a few extra sheets of our ML-3000 address labels, there are plenty of things to use them for. The primary use would be for Address Labels. However, if you regularly cook, and save your food in food containers in the fridge, you can use the ML-3000 labels for labeling them.
Things to include on the label might be things like the Date, the Day of the Week, the Name of the food item. You also might want to consider other things like checkboxes for Nuts/Peanuts for people with allergies. Maybe a check box for Low Sodium for people watching their blood pressure.
Here’s what it might look like:
Address Label

Bulk Labels

All of our front page labels come in case quantities. Each box has 100 sheets, and each case has 5 boxes. This packaging works well for a great number of our customers. However, there are some customers who need to cut down on packaging. This is where our Bulk Labels, or Bulk Pack Labels come in. Our Bulk Packs of Labels come in boxes of 250 sheets, and each case has 2 boxes.

Etiquetas de Dirección en Puerto Rico, Address Labels in Puerto Rico

Live in Puerto Rico?, and searching for a place to purchase some low cost high quality Maco Address Labels, or etiquetas de dirección, stop looking.
Although we do not accept orders from Puerto Rico on line, feel free to call us and place your order at 800-526-1155. Items are shipped using USPS, US Postal Service. Minimum purchase quantities may differ from orders shipping to the lower 48 states in the USA.
Address labels in puerto rico

ML-3025 Address Label Template

If you’ve purchased the ML-3025 Address label from us, or even another source, and you’re looking for a template for the ML-3025, look no further. Your search has ended. It’s the same layout as the ML-3000. As a matter of fact, it’s the same product. The only difference is in how the labels are packaged. The ML-3000 address label, which is the same layout as the Avery® 5160, is packaged in boxes of 100 sheets. The ML-3025, on the other hand, is packaged in boxes of 25 sheets.
But since you’ve made it to this page, we’ve made the ML-3025 template available right here:
ml-3025 address label template

Inexpensive Address Labels

If you’ve purchased labels here at MacoLabels.com, you know the quality of the labels we sell. That’s why we’ll never say “cheap address labels”. Inexpensive, yes, cheap, no. Once our customers find out how good Maco Labels are, they make the switch to Maco.If you’ve purchased Avery® Labels, you know what expensive is. They’re great labels, but so are Maco Labels. Maco Labels have a long shelf life, so if you buy in bulk, you’ll be confident that you’ll use your labels long before being close to the end of their service life.