Excel 2007

I am trying to do a mail merge from an excel database in which I performed a filter. The mail merge pulls in all the data – visible filtered data specified and nonvisible undesireable data that I filtered out. Is there a way to delete the excess data (that which I did not include in my filter) in order to save a new database with just the data I filtered out?