Knowledge Base

WD: Cannot Merge a Barcode Field Based on a Condition

PSS ID Number: 113213

Article Last Modified on 10/4/2002


The information in this article applies to:


This article was previously published under Q113213

SYMPTOMS

A BARCODE field nested in an IF field produces no merge result even when the condition is true.

CAUSE

BARCODE fields are a special type of Word field called a "display" field. Display fields produce their own results and, unlike other Word fields, the result of a display field cannot exist independently of the field itself (display fields can't be unlinked). Consequently, the result of a display field cannot be fetched by the IF field for its result.

WORKAROUND

To work around this problem, use either of the following methods.

Method 1

Use the Record Selection feature to merge only those records that have addresses in the U.S. After all these records have been merged, remove the BARCODE field and merge those records that are not in the U.S.

Method 2

Sort the data file by the country field so that all records for the U.S. are together. Using the mail merge helper, merge only the range of records that includes the country U.S. After all U.S. records have been merged, remove the BARCODE field and merge the range of records that includes countries other than the U.S.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

"Microsoft Word User's Guide," version 6.0, "Selecting Records to be Merged," pages 666-669; "Sorting Data Records," pages 670-671

Additional query words: usa bar code

Keywords: kbfield kbmerge kbprb kbualink97 KB113213
Technology: kbHWMAC kbOSMAC kbWord600 kbWord600a kbWord600c kbWord600Mac kbWord600NT kbWord601aMac kbWord601Mac kbWord95 kbWord95Search kbWord98 kbWord98Search kbWordMacSearch kbWordSearch kbZNotKeyword2 kbZNotKeyword3