To illustrate the problem, please have a look at the source data formats in an Excel worksheet: As a result, in a Word document, the data appears in the format in which it is stored internally in Excel, and not in the format applied to cells. The problems typically occur with numbers formatted as percentage or currency, or numbers containing leading zeros such as zip codes.Ĭause: By default, Microsoft Word uses the OLE DB connection, which pulls in the information but not formats. When performing a mail merge from an Excel worksheet, some of your numeric data may lose formatting after coming through the merge. How to keep leading zeros in mail merge.The troubleshooting tips below will help you fix typical Mail Merge formatting problems. Numbers properly formatted in Excel may not appear correctly in a Word document. Some fields might not be populated or filled with wrong information. As it turned out, using Word's Mail Merge to automate the creation of a document from an Excel worksheet may present lots of challenges. In one of our previous articles, we looked at how to mail merge from Excel to Word to send personalized letters or email messages. The tutorial shows how to keep formatting of numbers, dates, percentage and currency when doing a mail merge from Excel to Word or change it to your liking.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |