Thread: [Solved] Search for and replace merge fields in Word doc with plain text using VBA
View Single Post
 
Old 03-17-2025, 12:46 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
I can't see why merging shouldn't work for mergefields outputting dates or formatted numbers. At most, if the fields are remaining in the documents post-merge, your commented-out line of code:
oWordDoc.Fields.Unlink
is all that's needed (the equivalent of Ctrl-A, Ctrl-Shift-F9). Indeed, you can even do that without doing any merging. Either way, having converted all your fields to plain text, replacing the text results with your "simple codes within square brackets" should be a breeze.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote