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.
The 80 labels per sheet ML-8100 is normally used as a return address label. However, some customers use them simply as a numbering or coding label. We’ve used the 80 labels per sheet ML-8100 template as the primary document and created an Excel file as data file in our mail merge. Mail merges are not used exclusively for mailings. They’re used to insert all kinds of data into various types of documents. If you have a need to print cells with consecutively numbers, using Excel together with Word works great.
The first step is to create the Excel file with consecutive numbers. Lets say for instance you want to number your labels from 1 to 2000. We’ll also want to pad the numbers on the left with zeros. It just looks neater that way. First name the column A by typing the word NUMBER into cell A1. Select the entire first column by clicking on the column heading A. Once it’s selected, right click on the column, and chose Format Cells from the dialog menu. Then choose the Number tab, and click on the Category ‘Custom’. In the Type field, we just type 6 zeros, 000000. Now when you type the number 1 in cell A2, it’ll show as 000001.
To fill in the column, hold a right click on the lower right hand corner of the cell you just typed in. As you hold it, also press the Ctrl key, and drag straight down to the bottom of the page. Holding the Ctrl key will increment the values as you drag the mouse cursor down to however far you want to go. I went to 2000, and I renamed the file to 1-2000.xlsx
I’ve got to admit something here, we really didn’t need to format the NUMBER column, because if we use that as a merge field, Microsoft Word only sees what the original input was, eg. 1, 2, 3 …, and not the formatted version we see 000001, 000002, 000003 …. I forgot about that, but we’ll leave it here, just to show you how to format a column.
To create the left zero padded copy of the NUMBER cell, we make another column that copies the first using the TEXT() function. So in the cell B2, type =TEXT(A2,”000000″). Then right click on the lower right corner of the cell, this time, NOT holding the Ctrl key, just right click, hold and drag the cell to the bottom of the spreadsheet.
So now that we have our data, we just need the Primary Merge Document, shown below.
If you’re quick at copy and pasting using the keyboard and mouse combination, creating the above document should be pretty quick. Caution: in the last cell of the document in the lower right of the document, leave off the merge command «Next Record», because Word automatically advances the record to the next record at the end of the page. If you put the «Next Record» in the last cell, you’ll wind up skipping a record, and the next page will start at 82 instead of the correct 81.
And the merged result is below.