Thanks. Had to change your "Next aCC" line to above the ActiveDocument.SaveAs2 line and then it worked. It was saving multiple files or if I didn't fill in the subject then it would have the prompt pop up but it would also save the file without a name of the company in the file name since subject wasn't filled out.



Thank you very much for your help with this. You just made life a lot easier for my coworkers. Take care.

Sorry have one more question. I wanted to change the sPath from the desktop to our network Grive in one of the folders. When I replaced the entire sPath to this:

sPath = "G:\WP61"

The file saved only as far as the root of the Grive and also it did something weird to the file name. It put the Grive folder name that I wanted the file to be saved in, in front of the person's name. I did a test with the name John Doe and this is the file name it generated:

WP61Doe,John_10-28-2022_093118.docx