I feel your pain.  I'm sure you've noticed that 97 and 2000 have their own
way of merging, XP again is different, and 2003 is different still.  So, you
will need to test for the Office version and apply the appropriate merge code
for each.  It's not that difficult to do - let me know if you need the code.

Bottom line is that in 2003, you need code similar to the following:

(From 2003 help)
This example uses ODBC to attach the Microsoft Access database named
"Northwind.mdb" to the active document. The SQLStatement argument selects the
records in the Customers table.

Dim strConnection As String

With ActiveDocument.MailMerge
   .MainDocumentType = wdFormLetters
   strConnection = "DSN=MS Access Databases;" _
       & "DBQ=C:\Northwind.mdb;" _
       & "FIL=RedISAM;"
  .OpenDataSource Name:="C:\NorthWind.mdb", _
       Connection:=strConnection, _
       SQLStatement:="SELECT * FROM Customers"
End With

The problem here is that you need to fill in the SQLStatement.  As far as I
know (and believe me, I've tried), the only way to turn off the SQL prompt is
to actually retrieve all of your main documents and tell them not to connect
to the datasource.  Then re-save and close.  Once you have inserted all of
the merge fields that you need, unlnking the main doc from the datasource
shouldn't create any problems.  If you ever need to insert more fields, you
can always re-connect it manually, temporarily.

I had to punt by doing the above, because I have not succeded in "capturing"
the SQL prompt and dealing with it.  Anyone else been able to do it?

zkid