Step-4: Select Recipients to Merge Excel File to Mailing LabelsĪfter Step-3 by default, the ‘ Mail Merge Recipients‘ window will display all of the recipients from your Excel mailing list. In the end, click on OK after we select our excel worksheet named ‘ Merge Mailing Labels$’ from the pop-up window.After browsing we can see a new pop-up window like the image below.From that window, we will browse the excel worksheet that we will use to merge mailing labels. Then, a pop-up window like the below image will appear.In addition, click on the Browse option.To begin with, check the option ‘ Use an existing list’ from the ‘ Select recipients’ section.In this step, we will connect our Word file with an Excel worksheet. To merge excel files to mailing labels we need to link our work file with an excel worksheet. Step–3: Link Word File and Excel Worksheet to Merge Mailing Labels Then, click on the option ‘ Next: Select recipients’ at the bottom. Furthermore, from the new pane check the option ‘ Use the current document’.The above command will take us to a new Mail Merge pane.Moreover, click on the option ‘ Next: Starting document’ at the bottom.After that, from the ‘ Select Document Type’ section check the option Labels.The above action will open a mail merge pane.In addition, from the drop-down menu select the option ‘ Step-by-Step Mail Merge Wizard’.Then, from the ribbon select ‘ Start Mail Merge’.First, create a new document in Microsoft Word or open an existing one.In the second step, we will merge an excel file to mailing labels by placing mail merge documents in Microsoft Word. Step-2: Place Mail Merge Document in Microsoft Word Furthermore, select the same names for your column headings as those in the ‘Required for Address Block‘ section.Notice the terms in the ‘ Required for Address Block’ section such as First Name, Middle Name, Last Name, etc. Next, before approaching the next step we need to ensure some important things.So, when we will merge excel files to mailing labels, the column headers of our Excel sheet will convert into mail merge fields in a Word document.We’ve taken the First Name, Last Name, Address, and Country of five presidents to create the following dataset. First and foremost, create an excel sheet like the following image.So, to make you understand this method better, we’ll demonstrate the process to you in 8 steps. The entire process to merge an excel file to mailing labels with the help of Microsoft Word is simple but a little bit lengthy. Required Steps to Merge Excel Files to Mailing Labels Combine Excel Sheet to Mailing Labels.xlsx
0 kommentar(er)
