In this article I will explain the Skip Record If Rule used in Mail Merge. – What is it? The Skip Record If Rule compares the value of a field with a certain value. If the comparison returns true, the current record will not be merged. Example: Consider
One thing that may confuse a lot of programmers, is that the first row of an Access table is NOT necessarily the first record. For example consider the empty access table below: Lets say we copy the some data into the table: In the figure above the data being displayed in the
The Skip Record If Field is not visible by default: In order to delete the Skip Record If Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the SKIPIF Field: Step 3: Delete it: See
In this article I will explain the Next Record If Rule. Previously in the article below I’ve explained about the Next Record Rule: Mail Merge Next Record Rule (Mail Merge) It is assumed readers are familiar with Next Record Rule before reading this article. – What is
The Next Record If Field is not visible by default: In order to delete the Next Record If Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the NEXTIF Field: Step 3: Delete it: See also: Word,
In this article I will explain the Next Record Field of Mail Merge. The Next Record Field can be used to display multiple records in one document. – What is it? Consider the letter below: The letter consists of 2 greeting lines which belong to 2 separate records. By
The Next Record Field is not visible by default: In order to delete the Next Record Field you will have to make it visible first. Step 1: Press Alt + F9: Step 2: Look for the NEXT Field: Step 3: Delete it: See also: Word, Mail Merge