When using the Data Matrix font with a mail merge, the first line is off by one space in Word 2003

The first line is moved over to the left by one space when using the IDAutomationDMatrix font in Word 2003 mail merge, when connecting to an Excel spread sheet using IDAutomation's Microsoft Office Macro. After the first line, the barcode becomes indented by one space making it unreadable by a scanner.

This issue is a result of the integration of mail merge between MS Word and Excel. The Microsoft Office Macro inserts a space before every line to create a quiet zone around the barcode. MS Word, by design will remove the leading spaces of every record in the spreadsheet thus moving the first line over.

To get around this the Substitute Function in Excel needs to be used in the spreadsheet to remove the spaces and replace them with a null value.

For example:

This should be the resulting barcode in the mail merge document.

See also:

• Product Support Index

TSI

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