Excel 2007 - Filters and Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

texasaralynn@highstream.net - 12 Jun 2007 20:00 GMT

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?

Reply to this Message

Peter Jamieson - 13 Jun 2007 01:50 GMT

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

>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?

Reply to this Message