Problems merging with Excel

[cew47]

I am using Word and Excel 2003 for a salary letter mail merge. When I create
a filter on the query options in Word, in some instances, the first record
within that filtered data is dropped. For example, if the records I need are
in rows 10-25, and I enter the filter data to return those records, row 10
will not merge.

Also, the very first record in the entire Excel spreadsheet is always
included no matter what I put in the filter options. Any suggestions?

I've checked the data source information (Excel file) and everything is
correct.

 

[cew47]

I'm dying on the vine here. I'm willing to try anything at this point. HELP!!

 

[Doug Robbins - Word MVP]

I have no faith in Word/Mail Merge as a program for the manipulation of data
(such as filtering). If I were doing it, I would copy the Excel data and
Paste it into Access as a table and then use a Select Query in Access to do
the filtering and use that Query as the data source for a mail merge (though
I would probably use an Access Report if that was more suitable).

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP