Retrieve page numbers in Word doc from set of variables in Excel file
Hi, I have an Excel spreadsheet which has 1 column of variables (i.e., 100+ customer names). I also have a 400 page Word document with each page containing a customer's name. There are numerous instances of each customer in the Word document but the pages are not sorted (e.g., Joe Smith occurs on pages 2,5,18,49; Mary Smith occurs on pages 3,7,31,55,etc). I'm trying to retrieve the page numbers for each respective customer, that way when I print the statements, they will be in order by customer name. I had tried to merge several VBA scripts I found online but to no avail. I would be very appreciative if someone could offer some guidance. Thank you all in advance.
|