Word Mail Merge not bringing in filtered Excel range
I'm trying to use Word's mail merge feature to create labels. I have a spreadsheet in Excel which contains all my data. This is a filtered range based only on what labels I want to print. In Word, I'm given the option of selecting the full range or the filtered range when I link my spreadsheet, but when I select the filtered range, it is still importing everything from Excel, not just what I have filtered. I have almost 10,000 rows of data in Excel, so it is not feasible to uncheck each label I don't want to import. Does anyone know why it isn't bringing in only the filtered range, even though that's the option I'm selecting? I'm using Word and Excel 2007.
Thanks so much!