celebrityose.blogg.se - How to print address labels from excel mailing list

One of the best ways to start out with mail merge is to create basic mailing labels. Usually when I go through the steps with them, they realize it is much easier than it seems. In my past training classes, I have encountered many students who think it is too complicated since it involves several steps. If you are not using the mail merge feature, then you are missing out on a great tool. Sending out an incorrectly addressed card is awkward and a waste of money.As I was getting my holiday cards ready to send recently, I realized again how useful mail merge was to create labels in Microsoft Word.

Make sure you keep this list up to date when someone moves, gets married, or changes their name. I suggest having 25 people in each priority level since photo cards are printed in groups of 25. It sounds kind of cruel, but when the budget is tight it’s nice to have and easy way to sort the list. We also have a column to specify the priority of each person or family on our list. Other things you may add include phone and e-mail, names of children, etc.

State – abbreviate, as you would on an envelope.

Street – house number and street, unit number if needed.

Names – What you normal call them, such as Grandma & Grandpa or Joe from work.

Address To – this is to whom you want your mail addressed, such as The Smith Family or Mr.

In the top row, create the following headers: In an Excel file (you can also use Word, but Excel makes sorting easier) create a new spreadsheet.

Setting up the list the first time is a pain, but once it’s done you have a master list for basically all major life events and every holiday, so I think it’s worth it. Over the year we’ve added people, dropped people, and combined or separated as needed. We used our wedding invitation list and went from there. Next you’re going to need your card list. I like these 2″ x 4″ holly labels* (use with Avery Template 5163) because they’re a good size for any length address. If you’re good with graphics you can choose plain labels and design them yourself, otherwise there are plenty of pre-printed labels available. So here’s a step-by-step tutorial of how to do it yourself.įirst you’re going to need labels. Years ago I started using Microsoft Word to create my labels and I’ve never looked back.

It’s such a long process, and by the time I’m done my handwriting looks like I went to medical school. One thing I don’t like, however, is addressing them. They are actually the only cards we send all year because I think most cards are a waste of money.