Archive for December, 2009

Christmas lights on a Maco & Avery® label template

December 15, 2009

Here is a label template with Christmas Lights. It’s an ML-3000 template that’s compatible with the Avery® 5160 label template.
Christmas Lights on Maco ML-3000, Avery® 5160 Label Template


Printing address labels in Access is challenging

December 14, 2009

If you have Microsoft Access , you will be able to print labels no problem..maybe. The reason I say that is that some labels have no margins on the right or left. Some of our customers still have the Maco M-5363 that are discontinued. If you try to create a report in MS Access for this label layout, you’ll find that your minimum page margins are controlled by your printer. If your printer can’t print full bleed, then you’ll have to experiment around the report layout, and adjust your labels according to your printers margins. If your printer does print full bleed, all the way out to the edge of an 8.5 x 11 page, then you should be able to use the layout I created in Access unmodified. Here is the sample database in Access 2007 format:

Word Doc Columns converted to Merge Table

December 11, 2009

Among other assumptions, we assume you have Word 2007, and that you have a significant number of names so that cut and pasting would be impractical. The document could be formatted a couple of different ways. If a document has 2 columns, you can have actual columns, or things that look like columns, but are not really columns which I call pseudo columns. Pseudo columns are created like so:

Jack Frost [tab][tab][tab]Victor Frost
1 North Pole Way[tab][tab][tab]2 North Pole Way
North Pole, NJ 07601[tab][tab][tab]North Pole, NJ 07601

Bob Bright [tab][tab][tab]Maggie Moth
22 Ivan Ho Way[tab][tab][tab]393 Manlott Dr
Hackensack, NJ 07601[tab][tab][tab]San Juan, PR 00601

The [tab] represents a tab character. If you did it this way, it’s a bit messy but still workable. To fix it up you need to do a search and replace to convert all multiple tabs to single tabs so that your document will look like:

Jack Frost [tab]Victor Frost
1 North Pole Way[tab]2 North Pole Way
North Pole, NJ 07601[tab]North Pole, NJ 07601

Bob Bright[tab]Maggie Moth
22 Ivan Ho Way[tab]393 Manlott Dr
Hackensack, NJ 07601[tab]San Juan, PR 00601

Then select the whole document, and click on the “Insert” tab. Click on the “Table” icon and select “Convert Text to Table”. Make sure you have the “Paragraphs” radio button selected under the “Separate text at” section. Click OK, then you will have a table with two columns.
Next, you need to cut the second column, then paste it at the bottom of the first column. The result is that you will have two columns of data. Make sure you have a two blank cells as your last two cells in the first column. (Paste the cut column into the very last cell of the first column)
Ok, save the file as an Plain text. Make sure that you you have “MS-DOS” selected and “Insert line breaks” Selected, and “End lines with” “CR/LF” in the “File Conversion” popup window.
Ok, now open the text document in Word. You should have one column of names and addresses.
**actual column start point**
Now you have one column of names that you need to convert to a table. Do a search and replace. Replace all double paragraph marks (^p^p) with single manual page breaks (^m). Next, replace all single paragraph marks (^p) with tab (^t). Now replace all manual page breaks (^m) with manual line breaks (^l). You can now use the file as a merge file, or open the text file directly in Excel, save it as an Excel document and use it as the merge table.
Now I’ll hand it off to Microsoft for merging directions:…
The process would be much the same if you had two true columns. But first you would make the document into 1 column, and just go to the spot I marked as **actual column start point**, and continue.
Ok, so it’s not so easy, but it is the easiest way to do it in my opinion.
If you need a template for the 5164, we’ve got a few to choose from at:
Our ML-0600 is comparable to the Avery 5164 shipping label.
You could also use the data for an ML-3000 label which is Avery 5160 laser label and inkjet label compatible.

Little tiny Dreidles on an ML-3000 template, Avery 5160 Compatible

December 10, 2009

Found some tiny Dreidles to use on an ML-3000 template. Check the template out here
ML-3000, Avery 5160 compatible template with dreidle screenshot
Check out our twitter feed for holiday ribbons.

More Bang for the Buck with Butt cut labels

December 9, 2009

If you’ve got a printer that can print on every square centimeter of the surface of an 8.5 x 11 sheet of labels, then check out our M-5351 address labels. They’re butt cut, which just means that the labels go all the way out to the edge of the sheet. They’re a little bigger than the ML-3000 (compatible with the Avery 5160 labels). Its great to get the 3 extra labels on a page that the M-5351 will give you over the ML-3000.

Tis the season to move graphics in Word

December 8, 2009

If you have Microsoft Word 2007, and you have just placed the graphics into a document, you have to select and format them first. Select the “Home” tab. Then all the way at the right top of the screen, you’ll see “Select”. It’s just below “Replace”. Click “Select”, then click “Select Objects” from popup list. Then click on the picture or graphic you want to format. Click the object, and you’ll notice it has become active with the tiny resizing squares that you can click on to resize the graphic. Click on the “Picture Tools” Tab at the top right. At this point you need to decide where you want to anchor the graphic, and if you want to have the image in the background or have text wrapping. You’re going to have to start experimenting with the settings to see what’s right for you.
To be able to move graphics around the page, we at usually anchor the graphic to the page. To do that, make sure that the graphic is still selected, then right click on the graphic, and select “Format Picture” from the popup menu. Click on the “Layout” tab. Choose the “Wrapping style”, and then click on the “Advanced” button. Choose the “Absolute position” radio buttons, and make sure you have selected “Page” in both the “to the right of” and “below” drop down selection boxes.
At this point, you’re ready to move the graphic around the page freely. There are so many options to change the way your graphics behave. In the “Picture Tools” “Format” tab, click on the “Position” icon, and play around with the wrapping settings. Get ready to invest a little time into this.
Spice up your ML-3000 address labels, compatible with Avery 5160 label (laser label and inkjet label) with some graphics this holiday season.

ML-0600, compatible with Avery 5164 Label Templates

December 7, 2009

Just made up a few ML-0600 templates. They’re compatible with the Avery label Avery 5164 laser label / inkjet label. Use them as shipping labels, or use them for labeling boxes, any many other Things. It’s your world, we sell you the labels, you create the uses. Git er dunnn!

A Day that will live in infamy

December 7, 2009

It’s hard to believe it was 68 years ago today that the Japanese attacked the United States Fleet at Pearl Harbor.

Maco Tags?

December 4, 2009

Yup, Maco makes tags. They come as stringed tags, and plain unstringed tags. They’ve got many uses. Many industrial companies use them to identify equipment, from engineering firms, to chemical companies, and manufacturers. I guess you could call them industrial tags. So there it is, we don’t just make laser labels and inkjet labels that are Avery label compatible.

Had enough of the Tiger Woods coverage?

December 3, 2009

Ok I’ll stop. But before I do, these girls are coming out of the woodwork. Now Ashley Madison, the adult dating site has offered Tiger Woods a $5 million contract to partner with them.
Think that’ll happen? Nah, me neither.
What’s up with these guys? I guess the grass always seems greener on the other side of the fence.
Maybe if they kept themselves busy like we do, getting the universe high quality, low cost laser labels and Inkjet labels that are Avery Label compatible, they might not get in so much trouble. I’m just sayin.