I want to write VBA to extract sentences or paragraphs that contain specific words into a new word document.


E.g. the phrase I am looking for is 'the supplier' and it could be at the start of a sentence or in the middle of a paragraph
1.1 The Supplier shall perform the Services sothat they meet or exceed the applicable Target Performance Levels at all times.

1.8 If the Supplier fails tomeasure or report on a Performance Indicator in accordance with therequirements placed upon it by Part B of this Schedule, the Supplier shall bedeemed to have failed to meet the Target Performance Level for the relevantPerformance Indicator in the relevant Measurement Period, unless the Authorityotherwise agrees in writing and, where the Performance Indicator has anapplicable Critical Failure Performance Threshold, the Supplier shall be deemedto have failed to meet that Critical Failure Performance Threshold. For the purposes of paragraphs 3 below, Service Points shall accrue to theSupplier in respect of that deemed Performance Failure and following therelevant Service Period at the highest available level associated with thatKPI.