Plus, discover more ways to save time editing and formatting your Word documents at /Word.
And, for more options, find out how to customize the formatting of date and text mail merge fields. Try these fixes for formatting Excel mail merge fields to get the results you want in your documents.
* Including 0 in a numeric switch code creates a required or fixed position whereas the # sets a pattern without a required 0 or placeholder.
You should now see the actual field code for the field which should look something like Ĭurrency, with brackets around negative numbers and a hyphen for 0 valuesĥ numeric positions, zip code or other numberįor these formatting options, the precision of the displayed value for the Excel mail merge field is controlled by the 0.00. Or, right-click on the mail merge field and choose the Toggle Field Code option.
Microsoft Word 2010 - How to do a Mail Merge. 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. When performing a mail merge from Excel into a Word document it is common to have some formatting problems. 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. Incorrect formatting of numbers can cause errors in the merge.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. Format Numerical Data Correctly: Be sure that things like street numbers and zip codes are properly formatted for the way they should appear once the mail merge is complete.Also, make sure the headers you choose match the merge field names, which will also make it less likely errors will occur. To make it easy for Excel to differentiate between data and labels, use bold text, cell borders, and cell shading that are unique to the header row. A header row is a row containing labels that identify the data in the cells beneath it.