If the text doesn't fit, press Ctrl + A to select all, right-click and select Paragraph, select the Don't add space between paragraphs of the same style box, and click OK.Ĭlick Print, click OK, and click OK again. Give: Print mailing labels In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard. To add the address block, click Address block and click OK.

Drag the bottom right corner to make the dialog box bigger. When performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient list, which is typically an Excel workbook. Make sure the First row of data contains column headers box is selected and click OK.Ĭheck your list. Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard.Ĭhoose Labels, and then click Next: Starting document.Ĭhoose Label options, select your label vendor and product number, and then click OK.Ĭlick Browse, select your Excel mailing list, and then click Open. Once your mailing addresses are set up in an Excel spreadsheet (see the previous video to learn how), it's a snap to get Word to create mailing labels from them. You would simply head to their website, find the template that matches the stickers that you purchased (you can search by the number on the pack), download the template, and create your design within the guides they provide.This year, you can avoid that awful permanent-marker smell and get all your holiday card and package labeling done in a few quick steps. If you want to use a label that is more like a sticker, Avery has many templates for their stickers. Laminated or not, I typically just attach my labels with tape or velcro dots. To create mailing lists, envelopes, labels, and merge mail lists, you will go to the Mailings tab on the Ribbon.

Click the Mailings tab in the Ribbon and then click Start Mail Merge in the Start Mail Merge group. If they’re going to be in a higher traffic area, I’ll laminate them to protect them a little bit more. The first step is to start the merge using Start Mail Merge on the Mailings tab in the Ribbon: To start the merge and specify the main document for labels: Create a new blank Word document. Printing Your LabelsĪfter you’ve created your cute labels, what’s next? I typically print mine out (with my home ink jet printer) on white card stock so that they’re sturdy and cut them out by hand. In my opinion, it is the simplest program to navigate, and it still gives beautiful, fully-custom results. Though fancy programs and machines can be really great, it is possible to make pretty labels just using Microsoft Word.

Mircosoft office 2016 mail merge lables