Hi ?B?UkVWQQ==?=,

I did what you said about the No Blanks, BUT it is still bringing in ALL of the
rows in the worksheet. I am using the AutoFilter feature. Do I have to
Name the filtered area or something? In the mail merge I am Confirming Data
Source and must use the Microsoft Excel Worksheet via Converter (*.xls,*xlw)
to see my data. When the Open Worksheet window appears, I can choose the
CORRECT WORKSHEET, BUT the Name or Cell Range says only ENTIRE WORKSHEET.

Ah. The problem is with using "Worksheet via converter". Since the filtering
takes place ONLY in the Excel user interface, it Word can only "see" the filter
when you use a DDE connection.

The converter makes a copy of the worksheet DATA (nothing in the UI) and passes
that as a virtual file to Word, in memory.

If you want to use the converter, then you'll have to filter the data in the
Query Options dialog box on the same criteria you use in Excel.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)