Mail-Merge Returns Full Row of Data

< Back
You are here:
Print

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 IDAutomation’s 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 Universal Barcode Font.