Forum Discussion
Auto populate word document
Hello,
I would like advice on the best and most user friendly way to setup an auto populate a sheet for my work. I am looking that when a value is typed such as 1.1, it will populate three different areas of the sheet I need done. I have 71 codes that need to be recognized. At the moment I have been using {IF{REF BookmarkName} “1.1” “content”}. I now have this 223 different ways based upon each section of my sheet. But we can do mail merges and would like it a little bit more clear on where to enter the code.
I appreciate your advice and feedback on a method that would be best for this.
Thank you.
2 Replies
Use Words mail merge feature to connect to Excel data sources, or use XML binding to automatically fill in content.
Hello,
Sorry for the late reply. Is XML binding capable of auto-populating based upon a value that is entered? I do not believe Mail Merge is capable of this. I am looking to automate a warning letter for my company based upon the violation entered.
