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.
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 kommentar(er)
