Making a Data Table to Merge into Word Document
I am not sure this isn't the best thing to call this thread, but here goes.
First, I am not familiar at all with VBA but I think it has the ability to resolve my dilemma but the problem is responses always assume you are familiar with VBA which is no help. If anyone knows a KISS source for learning VBA for the current version of Word 365, I would appreciate a referral.
I have a case management system that does a terrible job of document assembly. Data needed for a merge is in numerous different files. I am required to select a record over and over again if because the data requested isn't sequential, which is a pain in the behind. It would be much easier to have an initial page with the collected data from all files (which means I only have to request them once), assigning them to variables, and then populating the document using the variables.
If possible, what I want to is table (so I can reference them) on Page 1 where I can the merge data to a variable. If I am on the right track, I foresee the table having 3 columns (field label, merge data, variable #). Then I could reference this table until I get the merge functioning properly and then I could just delete it.
Thanking you in advance, Rachael
|