| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel 2007 - Filters and Mail Merge
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? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Excel 2007 - Filters and Mail Merge
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 he print activedocument.mailmerge.datasource.querystring Peter Jamieson wrote in message ups.com... 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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge Filters | Mailmerge | |||
| ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
| Mail Merge Help Needed. Filters will not work. I am DESPERATE | Mailmerge | |||
| mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
| Mail Merge Using Date Filters With SQL Data Source | Mailmerge | |||
Hybrid Mode
