Word Merge

[Raynewp]

Hi,
I currently have a code that merges a Word Document with a single-record query that works quite well. I need to modify my code to run the merge on a query with multiple records. The caveat is I don't want to have one resultant merge file. I want each record to appear in a separate document. Do I need to loop and close the merge template each time or is there something in Word that can help me.
Thanks

[TonyES]

Hi,
One option is to loop through the records and do a single-record merge for each record. Another option is to merge all records into a single Word document, then use Word VBA to split the merged document.
Cheers!

[Raynewp]

Hi,
I will try the work around, thanks a lot for your time.
Regards.