Feb 03 2021 01:52 PM - edited Feb 03 2021 02:15 PM
Feb 03 2021 03:01 PM
Are you familiar with the VLOOKUP or XLOOKUP functions? Those could be used to retrieve the data in each row of the source data -- so long as there's some unique identifier (e.g., SSN or Employee ID or customer ID) to each row. You'd just have to lay things out so that there'd be an "off-screen" identifier that you'd change each time as the basis for the looking up of the data elements to fill in the document itself.
Then if needed, you could write a macro that simply runs through the database one row at a time and sends the resulting document to the printer. If there are only 100 rows, it might be just as time efficient to simply go row by row manually.
A question, though, if I may: you can use the Excel database as the source for a Word mail merge, and have a lot more flexibility in the formatting of the resulting document. Perhaps there's some compelling reason to use Excel to produce the merged document itself, but I'm skeptical. Word is far more suited to work with an Excel database to do that merging. And no need to write a macro. I speak as someone who did this kind of thing back during my working career in HR, producing hundreds of personalized documents from a huge Excel database....... I would use Word, though, for the merge. So that's why I'm curious what is leading you to want to do the merge in Excel.
Feb 03 2021 03:31 PM
Feb 03 2021 06:58 PM
Well, the main idea if you can do it in Word is to use Word's Mail Merge function, specifiying your Excel database as the source. Here are a couple of YouTube instructional videos that explain the process. They'll do better than anything I could put together on the spot.
There's a little bit of a learning curve, as is true for any such new technique, but once you've mastered how to place a few fields, I'm sure it'll go smoothly.
https://www.youtube.com/watch?v=mFqCvTOpOL0
https://www.youtube.com/watch?v=_Efb_oMgxEs