Posts Tagged ‘5160’

Oops I did it again.. Happy New Year

December 31, 2009

Ok, this is the last time, here are some more Happy New Year labels on an ML-3000 template. From all of us at MacoLabels.com, have a happy, healthy, and fulfilling 2010.

Happy New Year images on an Ml-3000 template, same as Avery 5160 template

Advertisements

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

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.

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.