Search > Mail-Merge Returns Full Row of Data when Excel is the Data Source
Mail-Merge Returns Full Row of Data
This issue only arises when using Excel as the data source for a
Microsoft Word mail merge where the data is in an Excel column that
contains a formula for
Code 128 Barcode Fonts, and there is data in the columns to the
right of that column. The issue arises when any column in Excel contains
the text string of 4"Î, Excel retrieves the fields to the right
of that column if the column contains data, placing a tab between each
column in the merged document.
The only way to resolve this issue is to make the barcode column
that contains the formula for conversion of the Code 128 barcode font
the last column to the right in an Excel spreadsheet. If another data
source is used such as MS Access, the issue does not occur.
Additionally, this problem does not occur when using the