Printing part of Worksheet with Merge Print Letters

  • Thread starter Thread starter paul
  • Start date Start date
P

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?
 
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.
 
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.
 
Back
Top