IDAutomation.com, Inc., Computers Hardware, Software & Services, Tampa, FL Contact IDAutomationView your cart in the IDAutomation Store  
Loading

Mail-Merge Returns Full Row of Data

Solution(s):

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.

Related Documents:
 © Copyright 2014 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses.