twinsunsky.blogg.se

• #Mailing labels from excel for mac how to

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.

#Mailing labels from excel for mac how to

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.