When in Word Mailmerge and you get to the step "select recipients" click on the
filter arrow for Acct# column and select Advanced then enter your criterion(a)
to filter upon.


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 11:14:01 -0800, tfarley
wrote:

I need to combine records that belong to "same" account number into one record.

My ultimate goal is to get data that has been exported into excel, into a
word document and do a mailmerge. I would like all data pertaining to Acct#1
in the spreadsheet to merge into the same word document and then all data
pertaining to Acct#2, then #3, etc.....

Is this an Excel question to prepare the data prior to the mailmerge OR is
this a Word question to handle using formulas within the merge?

Help?