Word - modify macro to loop search procedure and then extract pages as pdf

Hello

For what I am trying to do, I have found a macro that does something close but needs some modifications and I am looking for recommendations how to achieve what I am looking for.

I have a list of terms in an excel document that I am seeking to search a word document for, and then extract the page as a pdf for each result (2 search results are expected) - name the pdf = search term and place the pdf in a specific file.

I found a macro that does something very similar, however, it only accepts one search term and then produces a word document listing all the search results.
The original macro is located: http://www.vbaexpress.com/kb/getarticle.php?kb_id=158

Assuming I should, where should I insert a loop to loop the search throughout the word doc?

Where should I insert the code to make the search results into pdfs?

Would appreciate your recommendations/ideas

Thank you,

Adam
1. List of JVs.xlsxPayout Statements.docm

Here's a similar topic about extracting pages from PDF contains specific text: http://www.utteraccess.com/forum/Ext...-t2007085.html