I have a document previously generated by a mail merge. Each page is identical other than the data filled in by the mail merge.
I would like a VBA routine that reads the table on the top right of each page to determine the color based on the text in that table. Either Green, Blue, Yellow or White. Once the color is determined, fill in that table with the color plus the three tables on that page that describe the student's name and their car. If the color is White, then do nothing on that page. Pages 1 and 3 have the results I am trying to accomplish.
I have some VBA experience with Excel but I have never written any VBA for WORD. Any help would be appreciated.
Word 2007 or Word 2010