Hi!
You can use following approach:
Create a merge document and set up macro writing before you specify data source and ables/fields. After you're done, stop macro and save it. Than open Visual Basic for Word. Find your macro recorded in modules and look to code. You can alter it and than run so the query will be different. Really, merge is a query through ODBC driver, so I think there is a possibility to alter it.
HTH.
>Hi Vlad,
>
>I guess you are right, but I am doing the merge simply by creating a template in Word97, which simply pick up the fields directly from my DBF.
>
>I suppose I can put fields directly into word by using VFP commands - but I always find it rather difficult to find out how to code it.
>
>Rolf
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.