All Forum Posts by: Peggy Beene

I have a macro-enabled Microsoft Excel 2007 spreadsheet that does this through "Data Filter" mechanism. There is an input sheet for adding an entry on another data sheet. There are buttons for managing the data sheet. I just use the "Filter" feature on the data sheet, then click on my "Build" button to generate another data sheet with the filtered entries for mail merge with Word 2007.

If you are already familiar with Excel 2007 and Word 2007, then you should be able to build a similar tool in a few hours.

[shameless self-promotion removed]