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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Functionality 0
Long Data Fields in Mail Merge 0
Is it possible to create a mail merge with unformatted text links to mergefield? 1
Some mail merge fields not pulling into document 2
Automated mail merge problem 7
mail merge code template with connection strings 3
VSTO C# add in Outlook.Appointment error 0
Directory Mail Merge with table layout 2

Top