If you’ve read our old post ( https://macolabels.myshopify.com/blogs/news/pinfeed-label-printing-tip) on how to print the Maco 42-451 one across pinfeed label, you’ll note that the example template was for office 2007, which uses the Avery 4013 template, which is the same layout as the 42-451. If you’ve started using Office 10 or Office 365, you’ll notice that Avery 4013 is gone. But have no fear, there is another Avery number you can use. Use the Avery 4018. It’s the exact same layout as the 4013. The only difference is that the Avery 4018 is a removable label. Just click OK, and then “New Document”, and you’ve got a new template:
Here is the MS-1020 label template. Each rectangular label on the small sheet is 5/8″ X 1-1/4″. The labels run lengthwise on the long dimension of the sheet. So when running them through a printer, it’s probably best to use a vertical font, which is in the template below. These labels were originally designed for hand applications, and they are also removable. While customers use these templates to print, be aware that they can come off in the printer due to the fact that they are removable and there are also high heat conditions in some laser printers, and some very tight printer roller paths in some printers.
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 clic 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.
Do you hold events for which you need name tags? If so, we’ve got some name tags that are on an 8-1/2 X 11 sheet with card stock, and can be printed in a laser printer or inkjet printer. It’s the ML-8500. If you need a template for it, look no further. Click on the picture below for the ML-8500 template:
Here is a template for the MS-508 rectangular labels. Due to the small label size, 5/16″ X 1/2″, not much can fit on each label. Before printing, and wasting sheets of MS-508 labels, cut out plain paper sheets of the same size. Beware, printers have non-printing areas. Some printers non-printing areas are bigger than others. Depending on your printer, and there are many many printers out there in the wild, you could be able to print all the way out to the edge of the page. Or, you may not be able to print, or partly print on the top row, bottom row, left column or right column of labels. The Text Direction was changed to Vertical because you can just fit more text. Depending on your printer, you might have to do some fiddling with the cell margins to get things to print exactly on label on your particular printer.
Unless you’ve got some experience with peeling and applying labels, you just won’t appreciate the title of this blog article. Believe it or not, there is a correct way to to peel labels from the backing sheet. Actually, I have that backwards. I should say there is a correct way to peel the backing sheet from the label. If you peel the label off from the sheet, the labels tend to curl up, and that can be a pain in the neck to apply. Not a huge pain, but if you’re peeling a large quantity of labels, it is definitely better to peel the backing sheet off of the label. To do this, place the sheet on a flat clean surface with the label facing the surface, and the backing sheet facing up. Curl the page at the spot where the label is, and grab the edge of the label. Then pull the backing sheet off. The backing sheet should be curled and the label should remain fairly straight. You’ll have an easier time applying your label so that it is straight, and square, and looks neat.
According to the Farmers almanac, it’s going to be a long cold winter. You’ll have plenty of time to figure out what things you need to get rid of to make space for the new things you’re going to get. Plan ahead for your Spring Garage Sale. Here’s a Spring Garage sale sign that you can print on our ML-0100 Full Sheet Labels. You can print the Garage Sale sign directly from your browser, or download Inkscape, or use your favorite SVG editor to edit it to make it your own.
So our old MR-808 template had teeny margins for some reason, and it only fit one letter on each line. It’s not really the margins that are the problem, it’s the indents. So here’s a step by step process to fix it: If you look at the pic below, right above the first cell, you’ll see the left and right indent markers. To Change this, just select all of the cells by clicking in the first cell and holding and dragging to the lowest left cell, then click on the PAGE LAYOUT tab. Then under indent, fill in some minimal margins. We used .06. The numbers might disappear, but they’ll be there. To make things neater, because it’s a 1/2″ circle label, you’ll want to center the text Horizontally and Vertically as we did below by first right clicking, and then clicking on table properties in the pop up dialoge box. No when you click on the table properties, click on the cell tab, and choose the vertical centering icon. Centering horizontally is easy, just click on the center text icon in the Paragraph section of the Home tab in the “Ribbon” (the Ribbon is just the name for all of the tabs such as Home, Insert, Design, Page Layout etc) and voila:
There are times when you need your labels to be durable. To last through thick and thin, wet and dry, hot and cold. Well, we understand that there are also times when you need your labels to just go away, to wash away to be more precise. The DL-1205 performs just this task. These labels can be printed on using laser printers and ink jet printers.
We’ll be using the freely available Inkscape to create some old timey flourishes for your shipping labels. If you don’t have Inkscape, you should get it. You can also do the same thing in Adobe Illustrator, but why spend all that money when you really don’t need all that power and funcionality. It would be like buying a Semi-Tractor Trailer, when all you need is a pickup truck. You used to be able to copy directly from your Inkscape drawing, and paste right into your Microsoft Word document way back in Word 2007. Now in Word 2010 if you select and copy from your Inkscape drawing and paste it into your Word document, Word converts it into a low quality graphics format so now you need to perform an extra step. You must first save your SVG drawing as an EMF drawing. Then in Microsoft Word, click on the INSERT tab, and choose Pictures. Find your artwork, and when you insert it, it’ll be nice and crisp and clear, even when you zoom in. Here is our flourish: It’s not too difficult to make. You can start with a little spiral made with the spiral tool Shown in #1. Convert the spiral from a spiral object to a path by clicking on Path, then select Object to Path. Next use the Pencil tool to draw the shape in #2 but make sure that the smoothness is set to about 50, then clean it up by using the node tool on the left. In step 3 , duplicate the item by pressing Cntl-D, then make it smaller. Repeat the process. Next bring them close together as in step 4. Next, use the node tools to join the top nodes in each of the curves created in step #2. I duplicated step 4 and then shrank that copy even smaller. and then attached the spiral to the end. Resize to your liking, then duplicate it and flip it to create the mirror opposite that we see in step 5. Using the pencil tool, create a straight line to connect both #5’s and use the node tool again to connect the ends of the line, and you get #7 In #8 I just dragged down the center of the line with the node tool. Now you can squish it, expand it, squash it, blow it up, and make it look however you want. And now put it in your shipping label by exporting to a EMF and then importing it into your word document.
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. 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.
Customize your shipping label with some flourishes. Don’t just cut and paste them into an empty ML-0600 Shipping Labels template. What you have to do is first export the artwork to EMF format, then import it into your Microsoft Word Document. Microsoft Word shipping label template, which is also compatible with the Avery 5164 Template.