How Do You Mail Merge Address Labels Using Excel And Word?
Use the mail merge tool to prepare address labels for your business mailings. You might try ways to use this tool for personal use as well. Excel and Word work well together once you know how to get started. Open Microsoft Word. Select “Tools,” “Letters and Mailings” then “Mail Merge.” This opens another window to the right of your screen. Pick the type of document you want to work with. Choose “Labels” if you are preparing address labels. Choose “Next” at the bottom of the right-hand screen. Change the document layout to “Label Options.” A screen opens up to allow you to select the size and style of labels you would like. Double-click the label you want to work with. Choose “Select Recipients” from a currently saved list or start a new one. The three dots at the top of the right-hand window give you the choices. Select “Browse” and go to “My Documents.” From there, search for the file that holds the address data. Choose an existing Excel document. Once you find the right file, select
