Your code is working great! Thank you very much.
I just realized that sometimes the subject will be a company name and so the format we have with the comma won't work out too well. I'm going to make another copy of this file to use for companies only but instead could you adjust the VBA code so that it keeps the subject field in tact without a comma and reversing the first and last name? Also keeping the company name without spaces between each word? Example:
If user types "XYZ Construction LLC" into the subject field the file name would be saved as:
XYZConstructionLLC_10-27-2022_143225.docx (I was able to figure out how to change the file format from .docm to .docx)
Thanks for the help.
|