Once you are done selecting all your preferences, click “ OK.” 6. If the size you are looking for is not available, then you can create a custom size label by clicking on “ New Label” and manually inputting the dimensions. Here you can choose the label type and the appropriate size that matches the labels you are using. Customize Your Label OptionsĪfter selecting “ Labels” from the list, a “ Labels option” dialog box will appear. Select “ Labels” from the drop-down list. A drop-down list will appear with different types of document options that you may want to merge. To start the mail merge process, click the “ Start Mail Merge” button in the “ Mailings” tab. This is where the Mail Merge tool is located and other tools that are needed to complete the task. The next step is to access the mailings tab in the MS Words ribbon. This document will serve as your template for the labels. Open MS Word and Create a New DocumentĪfter preparing your Excel data, head over and launch MS Word to create a new document. Here is an example of what USPS requires. Note: Your carrier may need a delivery address for each customer, so make sure you have these details on hand. Here are some examples of commonly used fields, which are also the column headers:Ĭheck out the screenshot below as an example. Each column should represent a specific field and be named appropriately with column headers. Prepare Your Excel Dataīefore you even think about printing address labels from Excel, you need to have your data in order. Here are the steps when printing labels from Excel using Word. This is the most common way to print labels from Excel 2016 (and other Office programs) due to the fact that it is easy, quick, and convenient. In this guide, we will outline the steps to print labels from Excel using the mail merge tool in MS Word. How To Print Labels From Excel using Word Can You Print Labels Directly from Excel?.Can You Print Labels From Excel on Mac?.Print Labels by Changing the Page Layout.How To Print Labels From an Excel Spreadsheet Without Word.
How To Print Labels From Excel using Word.
0 kommentar(er)
