Replace Merge Field with Conditional If

bsforza · #1 06-15-2020, 09:13 AM

Hi, I'm having some trouble figuring out how to replace a basic Merge field with a conditional statement. I'm looking to, using macros, replace something like:

Code:

{ MERGEFIELD "A" }

with:

Code:

{ IF {MERGEFIELD "A"} = "Yes", {MERGEFIELD "T"}{MERGEFIELD "F"}}

This is what I've got going already:

Code:

Sub Ex()
Dim oFld As Field
For Each oFld In ActiveDocument.Fields
  With oFld
    If .Type = wdFieldMergeField Then
      If Trim(Replace(Replace(.Code, "MERGEFIELD", ""), Chr(34), "")) = "A" Then
         // Replace Merge Field with Conditional - Help
        .Update
      End If
    End If
  End With
Next
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace specific word inside a table in the Header with Merge field	Turin74	Word VBA	3	06-06-2019 06:17 PM
Form with conditional field.	Asuryan33	Word VBA	6	10-18-2017 03:45 PM
Conditional Field	CKTisdale	Word	1	04-10-2015 02:41 PM
Conditional merge fields in mail merge	Aude	Mail Merge	1	01-06-2012 07:38 PM
Replace all occurrences of one merge field with plain text	blankenthorst	Mail Merge	5	07-01-2011 05:18 AM