Forum Discussion
How to do the Excel equivalent mail merge?
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.