I'm using links to pre-populate word documents with data from an excel spreadsheet. I would like to create a word macro that will highlight all links within the document that have no data (when the excel file is empty). As it is, when there is no data, the links have nothing there so there is nothing to highlight. Maybe the macro could create a highlighted space for an empty link. I want to be able to easily find where I am missing data and it is not easy to see in the excel file because, depending on the project, there is a lot of missing data which is missing for a reason. Please let me know if you have any ideas. I am new to macros so this exceeds my capabilities. Appreciate your help!