The Mail Merge functionality provides a dialog to allow you to select data rows. Is there a reason you aren't using this?
Doing it with VBA is way harder and would probably require two separate macros to:
- First macro open Excel workbook
- and then allow the user to flag the rows to be processed
- Second macro to process the flagged rows