View Single Post
 
Old 12-28-2022, 09:29 AM
Meditating Meditating is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2021
Posts: 9
Meditating is on a distinguished road
Default 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
Reply With Quote