Hi, I've got a good one here I think:

I am trying to build a workbook that will limit the amount of extra
steps needed to get a set of names that are in a spreadsheet over to a
mail merge. So, what I would like to happen is:

1. User enters several rows of data on Sheet1.
2. User autofilters the rows by date, department, whatever.
3. User clicks a commandbutton to launch a macro that will send only
the filtered rows to MSWord to create the merge letters.

I think it will be pretty easy to set up the commandbutton to
automatically launch Word and create the merge docs, but I have no idea
how to send ONLY the filtered rows to the merge. Do I need to work
with a range?

Thanks a ton, as usual!

Chris