Printing part of Worksheet with Merge Print Letters

[paul]

How do you select records to merge print. Do you have to move them to a new
file? Can you specify the rows you want merging?

 

[Frank Kabel]

Hi Paul
what do you mean with 'merge print'.
Not quite sure but have a look at
http://www.rondebruin.nl/print.htm

 

[paul]

Need to print (for example - 20 records from Microsoft Excel with a letter
in Word). Know you can move these twenty records to another Worksheet and
select merge for all records. But can you specify the rows when printing.

 

[Dave Peterson]

In some (all??) versions of Word, you can specify a filter on what records you
want to mailmerge.

You may want to read this page:
http://word.mvps.org/faqs/mailmerge/MMergeQueryOptions.htm

It's part of Beth Melton's and Dave Rado's page:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

And from an excel standpoint, you can read David McRitchie's page:
http://www.mvps.org/word/FAQs/MailMerge

========
If it's difficult to come up with the rules of which records to include, you
could add another helper column that evaluates to Yes or No (to print or not).
Then use the MSWord "filter" on that.