In my office we have a set of auto text/quickparts that all end in ~~ (This can be changed fairly easily). When we see ~~ it is a tag that prompts us, as individuals, to use the quickpart.
Due to regulatory changes we need to add another 13 auto text pieces into the letters that we write. This will be a pain to do manually along with all the other changes we need to do. I want to make this all a heck of a lot easier for everyone (If this works it will literally 100's of man hours). This is a bit of a drastic change so the non-compliance issues will delay the benefits we are trying to provide.
I currently have a macro that searches out small things and replaces them with the correct things (ie. lower case veteran with upper case Veteran or word "Death" with the word "Survivor") The terminology has evolved over the years so words like these need to be updated. The basic letter writing tool needs a drastic rewrite but no funding means I have to find workarounds. The macro has been utilized 10% of the workforce and everyone uniformly says it saves them several hours every month (small but every little bit helps). I have a proposal that is currently at the higher level for this "tool" to be used by everyone, but due to the recent changes I mentioned above I want to make it better. Since I don't know VBA (I use the record function to do most things) I can't figure out how to get this to work. I'm really good at copy pasting :D and complex formulas in excel so hopefully with some direction this won't be too difficult for me to implement
What I want to do is:
1. Run a macro that finds specific text in the letters and replace them with a quick part autotext tag (I got this part covered)
2. The Macro will then find and activate each autotext tag turning it into the full text and tables, etc (This is what I have no clue how to work)
3. Repeat Step 2 until all of the Tags have been updated. (Also, no clue)
4. Stop (On my first attempt I made a loop that crashed the macro)
For the life of me I can't figure it out but I know it is possible. I just haven't been able to figure it out and these changes become mandated next week.
Help! Thanks
Bookmarks