Then, choose the Defined name which is MailingList here, mark the First row of data contains column headers and click OK. We’ll select our Excel worksheet like this and click Open. In this step, select Use an existing list under Select recipients.Īfter that, to find our Excel Worksheet click Browse. Step 03: Create Interlink Between Worksheet with Label to Create Labels in Excel Read More: How to Create Labels in Word from Excel List (Step-by-Step Guideline) Sixthly, in the Label Options dialogue, we will select the options like shown below.Īfter that, click OK and we’ll return to the Mail Merge window. Thirdly, choose Labels and then choose Next: Starting Document.įourthly, select Change document layout in the Select starting document option.įifthly, we will then select Label Options. The Mail Merge bar will now appear on the right side of the screen. Secondly, go to Mailings > select Start Mail Merge > select Step-by-Step Mail Merge Wizard. Step 02: Set up Mail Merge Document in Word to Create Labels in Excelįirstly, we’ll start with a blank document in of the versions of Microsoft Word 2007, 2010, 2013, or 2016.
Here it is MailingList.Īfter that, we need to save our Excel worksheet. Thirdly, in the Name field, we will enter a name for our address list. Secondly, go to Formulas > select Define Name from the Define Names group. We will then fill up the columns with informations like this. This dataset has columns with headers as First name, Last Name, City, State, and Profession. We’ll first make our dataset named as Mailing List of Citizens. We need to follow the steps below to create mailing labels in Excel. 7 Steps to Create Mailing Labels in Excel
0 kommentar(er)
