Posts Tagged ‘Avery Label’

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.

Advertisements

Some Mail Merge Examples

December 1, 2009

How you print mailing labels in MSWord depends on how you entered the data in your Excel spreadsheet. At http://www.macolabels.com we see customers who enter address data in Excel in a variety of ways.
The most common way to enter data in Excel is to enter data in assigned columns. The 1st column, column A might be NAME. The 2nd column, column B COMPANY, column C ADDRESS, column D CITY, column E STATE, and column F might be ZIP. Often times, column D, E, and F are put into one field as CITYSTZIP.
If you entered the data in this manner, you will need to create a primary merge document that looks like this:
http://www.macolabels.com/templates/ml-3000-primary.doc
This primary merge document is the same layout as the laser label that Avery makes, the Avery 5160 laser label. It’s also inkjet compatible.

And your address list could look like this:
http://www.macolabels.com/templates/addresslist.xls

For an in detailed tour of the mail merge procedure, check out Microsoft’s site:
http://office.microsoft.com/en-us/help/ha010349201033.aspx

Some of our users also enter their address data in to an excel spreadsheet as it might appear on a label. That is, each cell contains the data that prints out on a label.
Something like this:
http://www.macolabels.com/templates/addresslist2.xls
To make this document so that you can merge it with a primary document, make the document into a one column document so that it looks like this:
http://www.macolabels.com/templates/addresslist3.xls
You would then create a primary merge document that would look like this:
http://www.macolabels.com/templates/ml-3000-primary3.doc
Make sure you’ve clicked on the Mailings tab so that you have all the Merging functions to choose from.

Thanksgiving is over

November 30, 2009

The yearly weight gain has begun. I’m going to have to fast for two weeks to break even. Oh well, it’s back to work. if you’re doing some shipping this holiday season, and who isn’t, you might be using our shipping labels. It’s not too hard to add graphics to make the labels look good.
If you use Microsoft Word 2007, here’s how you do it.
Click on the Mailings tab, between the References and Review tabs.
Then click on Labels in the Create panel on the left.
The Envelopes and Labels dialogue box should pop up. Here is where you’ll select your label layout.
One choice for shipping label could be the Avery 5164 which has 6 labels per page and each label is 4″ X 3-1/3″.
Click on “Label”, and another dialog box will pop up and you can choose “Avery US Letter” in the “Label vendors” drop down selection box. Then choose 5164 in the “Product number” box. Click OK.
You’ll see that a picture of the label you selected appear in the Label panel.
Then click “New Document”.
At this point, you’ll have a blank document formatted to print Avery 5164 labels. To insert pictures, just click on the “Insert” tab. Then click on Picture. Choose the picture you want to insert. Once the picture is inserted, you’ll want to format the picture. Click on “Position” in the Format Tab. There are lots of options at this point, I could write pages of instructions because I’m only guessing what you need.
If you need high quality low cost labels, check out Macolabels.com . Our equivalent to the Avery 5164 laser label is the Maco ML-0600. You can check it out here:
http://www.macolabels.com/ml-0600.html

Manipulating Graphics in Word

November 23, 2009

Have you ever placed graphics in a word document, and formatted it so that the graphic appears behind the text, and then you can’t figure out how to select it? Well, you can select the clip art. Here’s how. Select the Home tab at the top left. Then select “Select” all the way on the right. It’s right under Find and Replace. Then select “Objects”. Once you do that, you’ll see you can click on and manipulate the graphics. I just used this to select a graphic in one of our Avery 5160 Equivalent Laser labels, at http://www.macolabels.com/ml-3000.html .
Here’s an example of graphics on a label layout:

Avery Labels doesn’t have these

November 13, 2009

Our customers love our ML-0400 quarter sheet shipping labels. Don’t bother looking for the same layout in an Avery Label, you won’t find one. Avery doesn’t make it.

Halloween Label Templates

October 23, 2009

We’ve just finished a couple of ML-3000 (comparable to Avery 5160 ) label templates for Halloween. Check them out at http://macolabels.com/halloween_templates.html