View Single Post
 
Old 10-18-2017, 01:16 AM
Office_Worker Office_Worker is offline Windows 8 Office 2013
Novice
 
Join Date: Oct 2017
Posts: 4
Office_Worker is on a distinguished road
Default Finding specific text in IF-fields across multiple Word documents

Hello,

I work for a company where we use several different labels (company names, logo's etc). In order to make sure our correspondence gets the label appropriate texts we've been using IF-fields to match the text to the label.

For instance [IF [MERGEFIELD Label] = "label1" "text1" "text2" ]

One of the labels is getting a new name and new label-specific information. We would now like to run a VBA script to find all the documents that have IF-constructs that call upon the old label name.

When we use the Explorer's 'content:' search option it only shows Word documents that have the label name in the body (plain text) of the document and not in the IF-constructs.

Is it possible to write a VBA macro that searches for text used in IF-constructs and then lists them in either a new Word document or an Excel document?

Much thanks in advance!
Reply With Quote