Tuesday, May 15, 2007

“Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.” Andy Rooney


Is there an easier way to do labels that to use mail merge? I have been asked this repeatedly from students. The answer is yes and no. First what is mail merge? When you want to print a bunch of labels at once you can create a database of names and addressees in Excel. Once you have completed this then you go to Microsoft Word and use their mail merge feature to import all the data. The problem is that this can be a hassle and seriously confusing. Also each version of Word is very different from the last. Now if you want a list that you can use for all your projects , different size labels or envelopes, then mail merge is the best way to do it. However if you want a list that is on one type of labels than there is an easy answer. Avery is the maker behind many labels that you buy. Even if you buy the generic brand it will still come with the Avery SKU number. This is usually a four digit number like 5160, common mailing labels. Avery has a set of templates that you can download and the open in word. They have all the lines laid out on the page so all you have to do is type in the boxes and your information should print perfectly on the label sheet. I use this all the time. I bought some small round labels for some spice jars. I got sick of using Cayenne instead of Cinnamon. So I downloaded the template filled them in and printed them off. Give it a try.

No comments: