how to mail merge labels from excel youtube

To add the address block, click Address block and click OK.

Drag the bottom right corner to make the dialog box bigger. It’s easy to make a mistake and end up with a page of labels you can’t. A4, a6), you can add a custom size and enter the envelope measurements yourself. on the mailings tab, click start mail merge > envelopes.Print envelopes on the mailings tab, click start mail merge > envelopes. Make sure the First row of data contains column headers box is selected and click OK.Ĭheck your list. Trying to print labels, envelopes, greeting cards, or anything else beyond standard letter-sized documents can be frustrating. Print labels or envelopes using mail merge with an excel. 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. Insert a merge field from your mail merge source. 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. Note, this will break the connection between your Excel file and Word document, as a result your mail merge source wont be automatically updated any longer. 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.

How to mail merge labels from excel youtube