Query String in Mail Merge XP

  • Thread starter karen lyons via OfficeKB.com
  • Start date
K

karen lyons via OfficeKB.com

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).
wordMailMerge:DataSource:QueryString = ip-filter.


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

Any help would be greatly appreciated.
 
Top