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.
|
Related Documents
and Keywords:
|
See also:
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.
|
Over 70% of Fortune
100 companies use IDAutomation's products to automate their businesses. |
|