![]() Or, it can combine several entries, for example the «AddressBlock» field. A merge field can correspond to one entry such as first name, last name, city, zip code, etc. In essence, when you mail merge labels or envelopes from Excel to Word, the column headers of your Excel sheet are transformed into mail merge fields in a Word document. The steps are essentially the same in Excel 2021, Excel 2019, Excel 2016, Excel 2010, and very similar in Excel 2007. Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.īelow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature. Prepare Excel spreadsheet for mail merge.Today let's see how you can leverage this feature to make and print labels from an Excel spreadsheet. Last week we started to look into the capabilities of Word Mail Merge. You will learn how to prepare your Excel address list, set up a Word document, make custom labels, print them and save for later use. Use different headers and footers for left- and right-facing pages: Select the “Left and right pages are different” checkbox below the Facing Pages checkbox.The tutorial explains how to do a mail merge from an Excel spreadsheet for labels. The outside margin is on the outside edge of each page. The inside margin is the edge of any page that goes into the binding. ![]() In page layout documents, you set header and footer margins, not page margins. Set top, bottom, inside, and outside margins: Click the arrows or enter values in the Header & Footer Margins section. Select the Facing Pages checkbox in the Header & Footer Margins section. Note: If the Document Body checkbox halfway down the sidebar is selected, this is a word-processing document and you should follow the instructions in “Set up facing pages in a word-processing document,” above. To learn how to edit headers and footers, see Add and remove headers and footers. ![]() If your document has more than one section, you may need to do this for each section. Use different headers and footers for left- and right-facing pages: Click in the toolbar, click an empty space on the page (so nothing is selected), then in the Headers & Footers section, select the “Left and right pages are different” checkbox. Set top, bottom, inside, and outside margins: Click the arrows or enter values in the fields under Document Margins. If your document zoom is set to Two Pages, left and right pages appear side by side in the Pages window. In Page Thumbnails view, the page thumbnails rearrange as two-page spreads. Select the Facing Pages checkbox under Document Margins. Note: If the Document Body checkbox isn’t selected, this is a page layout document and you should follow the instructions in “Set up facing pages in a page layout document,” below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |