Thanks for your help yesterday; today, it seems to complicate way past
my VBA abilities.

We now have 7 letters (1A-7G). What they'd like to do is:

1. Auto-filter a column in Excel to the rows that would get a specific
letter. (done)
2. Click a commandbutton that would:
3. Open the Word merge document that pertains to the letter filtered
in the spreadsheet.

Somehow this seems like it should be easy, but then it is hard in
chunks. I've got it through to the filtering, and all of the letters
are built and associated, and I'm pretty sure I can code the merge
letters to run the merge as soon as the document loads (via VBA). But,

How do I tell the macro in Excel to pick just the filtered range? And,
How do I tell it in the code which merge document to open?

I could probably just use the Case member to select the letter based on
the criteria in the Excel column that contains the name of the letter,
but I'm stumped before I even get this far.....

Thanks a ton -- I learn so much in here every day, but as George
Harrison said, "the more I learn the less I know..."

TomorrowsMan