First word of sentence IF and then
Please help. My brain is exhausted.
Here is what I am trying to accomplish:
I need 1 command that incorporates 5 rules that I can execute with 1 macro to any word document.
The rules relate to lists of words, which I have in excel.
Rule 1:
Add number lines to the document.
Rule 2: (Column A in excel)
1)Find specific words (column A) 2) highlight those words only 3)IF they are at the beginning 4)OR end of a sentences within the document, 5) 4)add phrase after the highlight "Does not meet writing standard."
I will then manually save the document and send it to a person to correct the highlight, 5)meaning the highlight can be removed.
Rule 3:
1)Find specific words (column c in excel) 2) highlight those words only 3)IF they are at the beginning 4)OR end of a sentences within the document. 4)add the alternative word (column d) in 5)blue
Rule 4:
1)Find specific words (column f in excel) 2) highlight those words only 3)IF they are at the beginning 4)OR end of a sentences within the document. 4)add the alternative word (column f) in 5)Green
Rule 5:
Insert a front page 2) Message: The following errors were noted in this document in 3)font color purple and 4) font size 14. Below the message 5) a table with 6)two columns that in includes 7)line number and row two 8)references
Rule 6:
Once I save the document and send it to the individual they are able to edit as normal.
Any help would be greatly appreciated.
|