Reply to thread

Message: [QUOTE="Graywolf, post: 5611884"] Peter, Sorry for the delay. I got moved to another project for a while, now I'm back. Tried the registry change with no affect on my results; I'm still not getting label output. When I step through the code in the debugger I can see my labels when I open the Word document because the template points to the predefined query in Access as the original datasource that was used when creating the label mailmerge. When I go to change the datasource by altering the SQLStatement argument of the OpenDataSource method, I lose my labels. Any other ideas? If I cannot find a resolution here, do you think it would be possible to change the SQL in the predefined query in Access? If I can, then, in theory I would only have to open the labels document and the altered predefined query would take care of itself. If you think this is possible, do you have any idea of how to change the sql statement in a predefined Access query? or is that a question for a different forum? Thanks again for all your help. [/QUOTE]