I have very little VBA knowledge and am copying the code in FAQ705-3237 (How to Automate Word Mail Merge From Access) but am confused about the datasource to be specified in the Word template document. The faq code has 2 SQL statements defined, one is the code for the QueryDef and the other, I think, will be "Select * from myquerydefquery where x = y".
My question is: In the Word template, how do I set the datasource to be my Access query when my QueryDef is only created at run-time?
Any help greatly appreciated,thanks.
My question is: In the Word template, how do I set the datasource to be my Access query when my QueryDef is only created at run-time?
Any help greatly appreciated,thanks.