I have set up an excel spreadsheet and a word document (merge), and have it working ok, but....

In order to select the rows for which i need to print in the merge document, i have set up a column called Record, and place a sequencial number ie 1 2 3 4 5 6 7 8 9 10 etc in it. ie in the excel spreadsheet.

In Word in the merge i enter query and enter say 5 in the fields called Record,
to get it to only print the excel row with a 5 in column called Record... this does work..

I would really like to only highlite the rows (in excel) that i need to print in the word merge
then open the word merge document and then just merge... ie not have to select record 5 etc...

Is there a way of doing it something like this ????

Appreciate any help..


Regards Trob