![]() ![]() ![]() Then, the Select Table box will pop out.Choose the desired Excel file and press Open.So, the Select Data Source dialog box will appear. ![]() You will notice that Use an existing list from Select recipients is checked. However, we need to link the Excel file to Word. STEP 3: Link Word and Excel for Merging Mail Labels Read More: How to Create Labels in Word from Excel List (Step-by-Step Guideline) So, choose Avery US Letter as the label vendor. In this case, you won’t be able to see all recipients together. Note: If you choose Avery A4/A5 in the Label vendors box, then you will get them one by one recipient. Finally, press Next: Select recipients.From Label vendors > choose Avery US Letter > select your desired Product number > press OK.Thus, the Label Options dialog box will pop out. But, if that option is inactive, choose Change document layout. Here, check the circle for Use the current document.Then, Step 2 of the Mail Merge will emerge. Choose Labels from Select document type > click Next: Starting document.Next, select Step-by-Step Mail Merge Wizard from the Start Mail Merge drop-down.Īs a result, the Mail Merge pane will appear on the right side of the Word window.First, open a Word window > go to the Mailings tab.Now, we have to set up Word to merge the Excel file to insert the Mail Merge Document. STEP 2: Insert Mail Merge Document in Word In this way, prepare the Excel file for Mail Merge.In this example, we insert the First Name, Last Name, Position, and Company.Then, input the necessary fields to create the Label.STEP 1: Prepare Excel File for Mail Merge Therefore, follow the steps below carefully to perform the task. This article will guide you through the required steps to Mail Merge Labels from Excel. You can import the necessary labels from Excel to Word by applying this Mail Merge. Using this feature, we can carry out numerous operations. MS Word has a cool feature called Mail Merge. How to Mail Merge Labels from Excel to Word: Step-by-Step Procedure Mailing Merge Labels from Excel to Word.xlsx ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |