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. Performing a Mail Merge in Word 2010 Before performing a mail merge, you will need a source from which the mail merge will pick up the addresses you want to include. ![]() To add the address block, click Address block and click OK. In the Label Options dialog box, choose your label supplier in the Label vendors list. Go to Mailings > Start Mail Merge > Labels. Drag the bottom right corner to make the dialog box bigger. With your address list set up in an Excel spreadsheet, Outlook Contacts, or a new list you created, you can use mail merge in Word to create mailing labels. To set up labels, open a blank Word document and go to Mailings > Start Mail Merge > Labels. Make sure the First row of data contains column headers box is selected and click OK.Ĭheck your list. To print labels from Excel, you need to prepare your worksheet, set up labels in Microsoft Word, then connect the worksheet to the labels. Click Open button, and select the Mr-Label’s Template file. Next Select Start from existing documentoption. Click the Labels tool in the Create group. (Remember to close Mr-Label’s template file.On the Mailings tab, in the Start Mail Merge group, choose Step by Step Mail Merge Wizard. Press Ctrl+c to copy the selection to the Clipboard. Press Ctrl+A to select the entire document. 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. Follow these steps: Open the existing document, the one that contains your labels in the Avery 5162 format. ![]() 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |