I have a FM database with around 200 entries. I have set up a letter in Office XP and connected to the FM files using ODBC. The problem is that I only want to generate letters on about 50 of the entries (based upon the entry of one particular field). For some reason, Office will generate letters from 200. How can I set this up so I can filter out the other files? Thanks.

Cameron...

Is doing a Mail Merge to Filemaker easy to do. A number of the staff at the college wish to Mail Merge FM Pro 5 to MS Word 2000, would the college administrator have to set up the ODBC link to allow the user to access FM.

Could it be as simple as doing a FIND in the FileMaker database first? Then perhaps only those 50 will be picked up by Office.

I don't know ODBC, so perhaps someone will come up with something more elegant. If not--and if the above doesn't work--seems like the simplest thing would be to Find the desired records in the database and export your desired fields to a tab-separated text file for use with Office.

Good luck.

Ernie