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.

Attached Files

Word List.xlsx (9.6 KB, 10 views)