You Say Mailing Stickers and Address Stickers, I say Mailing Labels and Address Labels

Language is a funny thing. We have different names for things in different parts of the country. If you’re from the Midwest, you drink Pop. Here in the Northeast, it’s called soda. I’ll never forget the first time I heard that one. Pop? What’s Pop? Ohhhhhh, you want a soda! Ha!. But the differences in language can be between places that are pretty close. For instance, I have relatives in Springfield, MA, the birthplace of modern Basketball, and the Basketball Hall of Fame. So one day just before lunch, one of my relatives up there in Springfield asked me if I wanted a Grinder. A what? A grinder, you know, some meat and cheese on long bread. Ahhh, you mean a Hero? Yesssss.
I guess the same thing goes for the terms Mailing Stickers and Address Stickers. I would never have thought to call them stickers. Stickers were the things that came free in a cereal box. Stickers of your favorite action hero’s (not Grinders), or stickers with slogans, or funny little comics that you could stick on the outside of your school book cover.
It’s pretty rare that I hear somebody call Mailing Labels and Address Labels by the monikers Mailing Stickers or Address stickers, but it happens. I haven’t come up with a geographical pattern yet. People in Warshington will say Mailing Stickers, as well as folks pahhking their cahh in Hahhhhvid Yaahhd, as well as folks with cayts in their layps watchin Da Bears in Chicago. maybe there’s some linguist out there who can figure it out.

Color Coding Label

Here’s a tip that should help when creating templates for labels on small sheets. When you create a template for color coding labels on a small sheet, the labels usually have very little margins on all sides of the sheet. The top, bottom, right and left margins can be as little as 1/64″ (.015625″). Since Microsoft Word 2007 label Templates are really just tables containing cells, and these tables take up the whole page on small sheeted color coding labels, you’ll discover that Microsoft Word will automatically force a second empty page. The reason for this is that after a table, Microsoft Word inserts a paragraph mark. Can you delete the paragraph mark after the table? If you can, let me know, but in the mean time, there are solutions.

The illustration below shows how I look when my face is superimposed on a color coding label template that I have just created only to find that I can’t get rid of the paragraph mark, to which the arrow is pointing.

color coding label template table page forced

The easiest fix for this is to select a tiny font size right before the paragraph mark, but after the table. Choose a font for which you can input 1 as the font size.

color coding label template table page forced paragraph menu

Another way to accomplish this is to put the cursor just to the left of the paragraph mark, and right click to show the pop up list, and pick Paragraph. In the Indents and Spacing section, make the “At:” as small as you can, I entered .06, which worked fine.

color coding label template table page forced paragraph dialog

And voila! Success!

color coding label template table page forced paragraph dialog

One Inch MR-1616 Circle Label

Here’s a shout out to Annette P for requesting a template for out MR-1616 Circle label. This particular Circle Lable comes on a small sheet, and the Circle label is 1″ in Diameter and is removable.

MR-1616 Circle Label

Keep in mind that these labels were originally designed for hand applications, and are removable. Also, the sheets are small, and may become lodged in your printer. Contact the manufacturer of your specific printer to see if your printer is recommended for this kind of label.

Controlling Address Label Field Length in Excel

When using an Excel file to complete a mail merge, keep your field lengths from getting out of hand, even if you’re using a 4″ wide address label like the ML-1000, ML-1400, ML-2000. If you’re using a database such as Microsoft Access, OpenOffice Base, LibreOffice Base, dBase, FoxPro, MySql, it’s pretty straight forward to control field lengths by just setting the field length to a fixed value. If you’re using Excel, it’s not as straight forward as that.
Although Microsoft Excel is not a database program, it does provide some functionality to control the length of your input fields. The Document shown, which you can download, named address-label-field-length.xlsx an Excel 10 spreadsheet contains a worksheet which has typical fields that would be used for a mail merge.
To prevent field lengths that are too long from being entered, you can place a limit on the field lengths for anyone who is entering the data.
Click on the Data tab shown highlighted in yellow.
Excel Data tab
Now select the entire column by clicking on the column marker. Here we selected FirstName, which has the letter A as the column marker.
Click on the Data tab. then select the Icon labeled Data Validation.
Click on the upper half of this icon that is circled in red.
Data Validation Icon
When the Data Validation window pops up, choose the Setting tab. From the drop down Menu titled Allow, choose Text Length. Then move down to the next drop down menu titled Data. Choose less than or equal to.
Then move down to the next drop down menu titled Maximum. Here we input a maximum of of 20 characters for the First name field.
Data Validation Icon
Now move to the Input Message tab. If you like, you may enter a message that will appear when you are entering data. Here we chose to enter a title and message that would remind the user of the maximum field length.
In the Title field, we put Firstname field Length , for the Input message field, we entered the words maximum of 20 characters.
Data Validation Icon
Next we clicked on the Error Alert tab. Since we do not want the user to enter a first name with more than twenty characters, in the Title field we entered the word Error, and in the Error message field, we entered the words Maximum field length exceeded.
Data Validation Icon
So now when a user enters a first name with more than 20 characters, an error dialog box will popup.
Note that now when a user clicks inside any first name field, a floating message box will appear with the data we input into the Input Message tab in the Data validation window.
Also note that now, when a user enters data that is greater than 20 characters in the first name field, the error dialoge box containing the data that we entered into the error alert tab in the data validation window.

Laser Labels

All of our Home Page labels are Laser Labels, meaning they are specifically designed for Laser printers. However, they are Inkjet Labels as well, designed to be printed using Inkjet printers. A long time ago before advances in paper manufacturing and Inkjet printing technologies, Laser Labels and Inkjet Labels were separate products, but now the quality of these papers are in combined in one product.

Laser Labels

Half Sheet Label

Our Half Sheet Label is a great product. There are so many uses for it. You can use it to print a UPS Shipping Label, a USPS Shipping Label, and a Fedex Shipping Label.
In a pinch, if you have spare stock, but are short on address labels, you can also use it as an address label, by manually cutting the sheet to size. It’s a quality label that’s versatile.

Half Sheet Label

Address Label Mail Merge

Here’s a quick tutorial on how to do a mail merge using a Microsoft Word 10 primary merge document and Microsoft Excel 10 Table containing a list of names and addresses.
It’s a concise tutorial. Download the sample primary merge document which is just an Address Label template and the Excel document that contains all the names and addresses so you can follow along with the mail merge. If you need to create a mailing list, the sample Excel document is a great template to use. You’ll see that once you’ve created your Address list in Excel, it takes literally just over 2 minutes to do a mail merge.

Address label mail merge tutorial