I have set up a report that uses a query taking a parameter from a form.
I want to export that report to Word as the formatting is much better.
I am a complete novice at VBA and could do with some help:
a) I am struggling to get the query to run using the parameter from the form.
b) I can open export the results of the query (using a dummy parameter) and open Word but cannot work out how to take the final step of merging the export file with the Word mailmerge document.
I want to export that report to Word as the formatting is much better.
I am a complete novice at VBA and could do with some help:
a) I am struggling to get the query to run using the parameter from the form.
b) I can open export the results of the query (using a dummy parameter) and open Word but cannot work out how to take the final step of merging the export file with the Word mailmerge document.
