Word Mail-Merge retrieves entire row of data when using Excel as a data source

This situation only occurs when using Excel as the data source for a Microsoft Word mail-merge, where the data is in a column in Excel 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 problem is, if any column in Excel contains the text string of 4"Î, then 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 solve this problem is to make the barcode column that contains the formula for conversion of the Code 128 barcode font the last one to the right in an Excel spreadsheet. If another data source is used such as MS Access, the problem also goes away.

See also:

• Unable to scan data printed with a barcode font

TSI mailmerge mail merge merging rows columns

Copyright © 2002-2006, IDAutomation.com, Inc. All rights reserved. All trademarks mentioned are the property of their respective owners.