Merge field won't populate after Datasource change

[Graywolf]

This question was originally posted at end of Dec. 08, but I can't seem to
reply to that thread anymore, so I'm starting a new question and pasting in
the previous info.

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.

 

[Graywolf]

I obviously had issues with posting, and now there seems to be several posts.
If the moderator can flush this question, please do. Sorry for any
inconvenience.

 

[Peter Jamieson]

I've replied to the original thread.

Peter Jamieson

http://tips.pjmsn.me.uk