![]() ![]() So, it’s time to printthe labels which we created in the previous step. Step-7: Use Created File to Print Labels in Excel Read More: How to Print Excel Sheet with Lines (3 Easy Ways) We can see that the labels are inserted one by one on the page in the format we wanted. Lastly, a new document for labels will open. ![]() Secondly, a new pop-up box will appear named “Merge to New Document”.From the drop-down, select the option Edit individual Documents.Firstly, go to the Mailings tab and select the option “Finish & Merge”.In this step, we will connect our Word file with an Excel worksheet. Step-6: Link Word File and Excel Worksheet to Print Labels in Excel Related Content: How to Print Multiple Sheets in Excel (7 Different Methods) Lastly, we get a page like the following one.To apply this change in the remaining records of the table select the option Update Labels from the Mailings tab.Like the previous step input all the labels one by one.Now, the field First_Name appears in the first box of the table.Then, from the drop-down click on label First_8Name.Next, select the option Insert Merge Field.In the beginning, select the first label field from the table and go to the Mailings. ![]() Let’s see how we can insert mail merge fields. We will use input data from the excel worksheet in the final table of Step-5 to create labels. Now we need to add mail merge fields to create labels with our excel data. Step-5: Insert Mail Merge Fields in Microsoft Word Related Content: How to Print to PDF in Excel VBA : With Examples and Illustrations It links the word file with the excel worksheet.
0 Comments
Leave a Reply. |