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

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia