Hi, We've been creating mail merge documents using a datasource with Word 2000 with the following code to exclude items from the completed mail merge document. On using XP this code no longer works - the document is displayed, but extra lines are created.

wordMailMerge:OpenDataSource(ip-datafile, 4).

ip-filter = substitute("SELECT * FROM &1 WHERE (&2)", ip-datafile, ip-filter).
wordMailMergeataSource:QueryString = ip-filter.


NOTE: ip-filter = ((sernum is NULL))

Any help would be greatly appreciated.

--
Message posted via http://www.officekb.com