Tag Archives: IF

No Thumbnail

If/Else Then Do Nothing in Excel VBA

When we don’t want to do anything in an If-then-else statement, believe it or not, we can simply not place any code! This is the most straightforward way to ‘do nothing’ in VBA. VBA does not have a specific statement that can be used for

How to Use IF OR Statements in VBA

In VBA, IF OR is the combined utilization of the IF statement and the OR keyword. Particularly, the OR keyword is used to construct the logic of the condition statement. The syntax for the combined IF OR statement is as follows: IF [condition statement 1]

Word IF Then Else Rule (Mail Merge) Insert Fields

Previously in the article Word IF Then Else Rule (Mail Merge) I’ve explained how you can use the If Then Rule in Mail Merge. In that article the If Then Else Field would insert a text string based on the result of the comparison. In this article I will

Word Skip Record If Rule (Mail Merge)

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

No Thumbnail

Excel Formulas and Function, Finding Text Within Another Text, Find()

The function FIND() searches for a specific text expression inside another text and returns the first index which the text was found. You can download the workbook related to this article here. Jump To: Syntax Example 1 Example 2 Syntax: =FIND(Text_to_Find, Text_to_Search_in, Starting_Index) Text_to_Find: The

Word, Delete Next Record If Rule (Mail Merge)

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,

Word IF Then Else Rule (Mail Merge)

In this article I will explain the IF Then Else Rule used in Mail Merge. Note: It is assumed readers are familiar with mail merge before reading this article. – What is it? I’ve previously explained how you can add fields to a document. These