Excel 2007 - Filters and Mail Merge texasaralynn[ at ]highstream.net 6/12/2007 7:00:47 PM I am trying to do a mail merge from a filtered set of data (using Excel and Word 2007); however, Word pulls all entries (even those not included in my filter) to finish the merge. How can I delete those entries that I do not want included (those not included in the filter) without having to do this one by one?

Re: Excel 2007 - Filters and Mail Merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/13/2007 12:50:10 AM After you have applied your filter, can you open the VBA Editor (in the Developer tab in the RIbbon), enter the following in the Immediate box, and post the result here: print activedocument.mailmerge.datasource.querystring Peter Jamieson <texasaralynn[ at ]highstream.net> wrote in message news:1181674847.733243.29970[ at ]d30g2000prg.googlegroups.com... [Quoted Text] >I am trying to do a mail merge from a filtered set of data (using > Excel and Word 2007); however, Word pulls all entries (even those not > included in my filter) to finish the merge. How can I delete those > entries that I do not want included (those not included in the filter) > without having to do this one by one? >