![Import excel into word for labels](https://kumkoniak.com/51.jpg)
![import excel into word for labels import excel into word for labels](https://i.ytimg.com/vi/K2JEkRamSEU/maxresdefault.jpg)
When you see formatting problems, how can you format the Excel mail merge field to accurately display the formatted number in a Word mail merge main document? The solution to controlling the number and currency formatting of Excel data in Word is to add a numeric switch (previously called a picture switch) to the mail merge code or MERGEFIELD. You might also see formatting issues with other numbers that are displayed as text such as zip codes, lease or property numbers, and other identifiers. For example, a dollar amount of $1,234.00 in an Excel worksheet used as a data source may display as 1234 in a Word document. However, you may notice a glitch that happens when you create a mail merge in Microsoft Word with Excel data, that is, the number formatting in Excel doesn’t show up correctly in the Word document. Click Print Documents to print the labels.The mail merge feature in Microsoft Word is a time-saving option to create repetitive documents from letters to contracts to emails to labels and more.If everything looks ok, click the Finish & Merge button.
![import excel into word for labels import excel into word for labels](https://www.labelplanet.co.uk/_images/_wp/Label-Templates-Mail-Merge-Arrange-Your-Labels.png)
![import excel into word for labels import excel into word for labels](https://cdn.educba.com/academy/wp-content/uploads/2019/06/how-to-print-labels-from-excel-step-1.3.png)
If you want to preview more than the first page, click the arrow pointing to the right while still in preview mode to show other pages.To make sure everything looks ok, click the Preview Results button, which should show each label and a different address for each label.All other labels should have ">" to step through each address field and print the address block in each label. The first label should only have the ">" field.Click the Update Labels button to update all fields.Once the address is being displayed properly, click OK to place the ">" field into the first label.If the address is not being displayed properly, click the Match Fields button and change how the fields are being matched.Click the Address Block option in the Ribbon and verify the address is properly formatted.If the CSV file inserts properly, ">" should appear on each of your labels. In the Select Data Source window, point Microsoft Word to the location of your CSV file and click OK.After the labels are created, click the Select Recipients button in Mailings and then click Use Existing List.Search for xxxxx template, where xxxxx is the product number you are trying to find. If your label product number is not listed, you can often download the template for your labels from the manufacturer's website.
![Import excel into word for labels](https://kumkoniak.com/51.jpg)