I use Excel as my data source, and do mail merge using MSWord. I currently
have a master sheet which of course holds all the information. I have other
sheets which hold filtered data. Two Questions.

Is there a way using MSWord to select the filtered data from the main sheet
if I use the Data filter and select say USA in the country field. That way I
could eliminate all the other sub sheets, and filter the data using before
the merge. When I try now, I still get all the data from the sheet.

If the answer to the above is NO, then is there away that when I enter new
data into sheet 1 (Master Sheet) that the data will automatically update in
the sub (Filtered) sheets?

--

Regards
Michael Koerner