how to do a mail merge in excel for labels

So that's why I'm curious what is leading you to want to do the merge in Excel. 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. Word is far more suited to work with an Excel database to do that merging. Perhaps there's some compelling reason to use Excel to produce the merged document itself, but I'm skeptical. If there are only 100 rows, it might be just as time efficient to simply go row by row manually.Ī 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. 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. 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. 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. Open the Mailings tab again and click on Finish & Merge, then Edit Individual Documents.

How to do a mail merge in excel for labels