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.
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:
Does anybody out there remember using Word Perfect 5.1? We used to use it for doing mass mailings. Forget about graphical user interfaces. This was plain beautiful blue background with white text. It was actually pretty powerful. We used to print thousands of address labels and merged letters with it. There weren’t too many fonts, but you could buy nice fonts. It got even better with 6.0 which came with a binary editor. You could edit any file. Good stuff. It was a simpler time. And by simpler, I mean more complicated for the end user. Let’s face it Microsoft Word is much easier these days than Word Perfect 5.1 ever was.
If you still feel the need to get back to WordPerfect 5.1 under Windows 7 or 8, you’ll need to get an emulator. There are a few things you can do. You can download DosBox, which is great if you want to run old DOS programs. You can also download Oracle VirtualBox. If you use VirtualBox, you’ll need a copy of whatever operating system under which you’ll run WP5.1. That means, you’ll have to have an old copy of DOS, or Windows 3.1, 95, 98, XP, or Vista.
With 21 labels per page the M-5360 address label offers a bit more room than the M-5361 30 up label. “30 up” is the term we use in the biz just to say how many labels are on the page. So the M-5360 is 21 up. Conveniently this label has a very similar number to the Avery product: Avery 5360.
If you still cant find a template for this label, and don’t want to take the time to create one, we’ve got the template right here for you.
Click on the picture below to download the template in Microsoft Word.
Remember, the grid lines that show in the above document can be turned off and on when you view the Word document. If you don’t see any grid lines, it doesn’t mean that you don’t have labels, you just need to turn on the grid lines. Check out our blog post on how to do that here: Seeing the Label
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.
When it comes to address labels, www.macolabels.com is your one stop shopping spot. We carry the same size address labels as Avery’s popular sizes.
our most popular address labels are the ML-3000, ML-2000, ML-1000, ML-1400, and ML-1450. Our labels are high quality, brand name, nicely packaged, and priced to save you a lot of money.
Address labels can be a tough thing to shop for, if you don’t know what you’re looking for. Maybe you’re in the shipping department of a small company, or maybe you work in the office of some religious institution that needs to do mailings to thousands of recipients. Our ML-3000 labels are perfect for these large mailings. They’ll run through your printers with no problem, and they’ll stick to your envelopes after you applied them. You won’t catch our address labels falling off on the job. The ML-3000’s are perfect for a nice simple mailing list with Name, Address, CityStateZip.
If you’re unaware that there was a free Operating System, then let me introduce you to Ubuntu. Ubuntu is a Unix like Operating System that functions like Microsoft Windows. You can run Word Processing, Database, Drawing and Spreadsheet programs that are free. Open Office contains all those things. Which you can then use to create the Address Labels or shipping labels that you need.
Ubuntu is super easy to set up. What’s really neat, is that you don’t have to install it as the main operating system on your machine. What you can do is download yet another free program called Oracle VirtualBox.
With VirtualBox, you install any operating system as a Virtual machine. So you can take Ubuntu for a test drive to see how you like it before installing on your hard drive as your primary operating system. You don’t need to spend all sorts of money to be productive and start printing address and shipping labels with expensive microsoft products.
Sometimes you just don’t need to have the quality of laser labels when doing your mailings. Our 42-451 pinfeed label is just the ticket for printing on dot matrix printers. You can print one label at a time, or you can print the whole box of 5000 labels. So there’s no need to waste a whole sheet of labels, like when you print the ML-3000 labels in a laser printer. There’s only so many times you can run one sheet of ML-3000 sheet through a hot laser printer without affecting the quality of the sheeted labels. So drag out your old pinfeed dot matrix printer, and get your money’s worth.
There’s no excuse not to give your address labels some flare. Especially when you’ve got Inkscape and the Gimp to help you create some nice flourishes. Use your hidden artistic ability, and make your address labels look classier.
Here’s a ML-1000 label template that is used for address labels that is equivalent to the Avery 5163 label template.